At 13:23 -0400 9/19/02, Steven Kreuzer wrote: >SELECT MAX(id_field) FROM table
That won't give you the correct answer if some other client gets in there an inserts a row before you have a change to get the MAX() value. LAST_INSERT_ID() is designed for this; it's not affected by whatever other clients are doing. >SK > >On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote: > >>What is the SQL to get the created AutoInc ID from a row that I have just >>inserted? >> >>Tim Davis >>Sunbelt Systems Concepts, Inc >>[EMAIL PROTECTED] >>Client/Server Database Programmer/Analyst --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
