At 12:29 -0400 5/4/02, Harrison C. Fisk wrote:
>Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can show
>you the next auto_increment value.
There is no guarantee that this value will actually be used for the
next AUTO_INCREMENT value. Suppose another client issues the following
query:
ALTER TABLE tbl_name AUTO_INCREMENT = 123456;
If you were relying on what SHOW TABLE STATUS said, you'd be hosed. :-)
>Although I can say I wouldn't really ever use it except for personal use,
>not in an actual application.
>
>Harrison
>----- Original Message -----
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Son Nguyen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, May 04, 2002 12:16 PM
>Subject: Re: Get the next AUTO INCREMENT value for a column
>
>
>> 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.
---------------------------------------------------------------------
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
