List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 4 2002 4:16pm
Subject:Re: Get the next AUTO INCREMENT value for a column
View as plain text  
At 9:01 -0700 5/4/02, Son Nguyen wrote:
>   CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text, value
>text, Primary Key (ID));
>
>   INSERT into test1 (name, value) values ("test1", "value1");
>
>   INSERT into test1 (name, value) values ("test2", "value2");
>
>   DELETE from test1 where ID=2;
>
>   How can obtain the CURRENT value of next ID AUTO INCREMENT value
>(which is 3 right now)
>
>
>
>
>         Son Nguyen
>mysql, query

You can't.  AUTO_INCREMENT values are not available until you generate
them.
Thread
Get the next AUTO INCREMENT value for a columnSon Nguyen4 May
  • Re: Get the next AUTO INCREMENT value for a columnPaul DuBois4 May
  • RE: Get the next AUTO INCREMENT value for a columnRoger Baklund4 May
  • Re: Get the next AUTO INCREMENT value for a columnHarrison C. Fisk4 May
    • Re: Get the next AUTO INCREMENT value for a columnPaul DuBois4 May
  • Re: Get the next AUTO INCREMENT value for a columnArthur Fuller5 May
  • Re: Get the next AUTO INCREMENT value for a columnAlexander Keremidarski6 May
Re: Get the next AUTO INCREMENT value for a columnRance Hall6 May