Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can show
you the next auto_increment value.
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
>
>
>
---------------------------------------------------------------------
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
