[thelist] MySQL generated id

Anthony Baratta Anthony at Baratta.com
Thu Sep 20 13:50:05 CDT 2001


At 11:28 AM 9/20/2001, you wrote:

>Is there anyway to immediately have access to the id number generated when 
>the record is inserted?

SELECT LAST_INSERT_ID();

http://www.mysql.com/doc/G/e/Getting_unique_ID.html
----
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."






More information about the thelist mailing list