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
__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
---------------------------------------------------------------------
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
