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
