Re: Simple question on auto_increment

mario wrote:
> Hello,
>
> really a mysql question. Pls. help anyway.
>
> Is there a simple, common way to implemt the following:
> Say I have a table with a id autoincrement field.
> I wish to insert a record but just ist id value, get back the id value,
> use it to update the record.
>
> Do I need three separate mysql queries? Is there some trick I may use?
> Thanks Regards mario
>
>
www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id

(of course for your example to work all the other fields would have to
be nullable)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Simple question on auto_increment

Hello,

really a mysql question. Pls. help anyway.

Is there a simple, common way to implemt the following:
Say I have a table with a id autoincrement field.
I wish to insert a record but just ist id value, get back the id value,
use it to update the record.

Do I need three separate mysql queries? Is there some trick I may use?
Thanks Regards mario

--
mario

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Simple question on auto_increment

WOW! perfect, thanks a lot
mario

On Mon, 2006-11-13 at 16:16 -0500, Brad Bonkoski wrote:
> mario wrote:
> > Hello,
> >
> > really a mysql question. Pls. help anyway.
> >
> > Is there a simple, common way to implemt the following:
> > Say I have a table with a id autoincrement field.
> > I wish to insert a record but just ist id value, get back the id value,
> > use it to update the record.
> >
> > Do I need three separate mysql queries? Is there some trick I may use?
> > Thanks Regards mario
> >
> >
> www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id
>
> (of course for your example to work all the other fields would have to
> be nullable)
>
--
mario

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Simple question on auto_increment

> www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id
>
> (of course for your example to work all the other fields would have to
> be nullable)
>

Or even the MySQL function LAST_INSERT_ID():
http://dev.mysql.com/doc/refman/5.0/en/information-functions .html#id2725312

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php