Of course, if you do LAST_INSERT_ID, then try to use the value while someone else is doing an insert, you're in the same boat. Neither method is reliable without a lock.
james montebello On Tue, 29 Jan 2002, Paul DuBois wrote: > At 15:16 -0800 1/29/02, James Montebello wrote: > >SELECT MAX(id) FROM table; > > > >will get you the highest value for 'id', that +1 will be the 'next' value, > >until someone inserts a new row into that table. > > Which may already have happened between the time you created your record > and the time you issue the SELECT shown above. In which case, you'll get > the wrong result. Use LAST_INSERT_ID() instead. > > > > >james montebello > > > >On Tue, 29 Jan 2002, Joel Wickard wrote: > > > >> database,sql,query,table > >> > >> > >> I need to find out what the next value will be in an auto_increment field > > > will be. could someone help me out with the select statement? > --------------------------------------------------------------------- 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
