I believe this approach work in a single connection environment and it has a potential problem when it is running in a concurrent system. What happens if there is another insert occurred through another connection just before this statement being executed?? The result of this statement would not be id you are expecting.
Regards, Michael -----Original Message----- From: Steven Kreuzer [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:24 AM To: Davis, Tim Cc: Mysql (E-mail) Subject: Re: Auto Increment ID of Inserted Row SELECT MAX(id_field) FROM table 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 > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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