List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 29 2002 11:25pm
Subject:Re: next insert id
View as plain text  
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?

Thread
next insert idJoel Wickard30 Jan
  • Re: next insert idJames Montebello30 Jan
    • Re: next insert idNathan30 Jan
      • Re: next insert idChristopher Thompson30 Jan
    • Re: next insert idChristopher Thompson30 Jan
      • Re: next insert idJames Montebello30 Jan
        • Re: next insert idPaul DuBois30 Jan
    • Re: next insert idPaul DuBois30 Jan
      • Re: next insert idJames Montebello30 Jan
        • RE: next insert idRoger Baklund30 Jan
        • Re: next insert idPaul DuBois30 Jan
  • RE: next insert idJohnny Withers30 Jan
    • Re: next insert idlaszlo30 Jan
      • Re: next insert idPaul DuBois30 Jan
  • Re: next insert idPaul DuBois30 Jan
    • Re: next insert idPaul DuBois30 Jan
      • Re: next insert idJames Montebello30 Jan
        • Re: next insert idPaul DuBois30 Jan
        • Re: next insert idDL Neil30 Jan
          • Re: next insert id (slightly OT)William R. Mussatto30 Jan
            • Re: next insert id (slightly OT)DL Neil30 Jan
              • Re: next insert id (slightly OT)William R. Mussatto30 Jan