MySQL :: Re: How do you get the @@identity for the record just inserted?

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: How do you get the @@identity for the record just inserted?

Posted by: Reggie Burnett
Date: January 24, 2005 08:49AM

Yes it can be done at the same time as the insert. The following SQL is very common for this sort of thing.

"INSERT INTO mytable VALUES (NULL, ?name); select last_insert_id()"

-reggie

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 12:54PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 12:58PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 03:38PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 03:48PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 03:52PM

Re: How do you get the @@identity for the record just inserted?

Timothy Graupmann

January 23, 2005 04:08PM

Re: How do you get the @@identity for the record just inserted?

Reggie Burnett

January 24, 2005 08:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.