Re: next insert id

[Paul DuBois]

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?