Resetting auto_increment

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear List -

Thanks for all your help.

How do I reset auto_increment so that the primary key will start from 1. The primary key is now 2421. I have deleted all the data in the table and started over, and the primary key just increments from its previous value. Setting auto_increment=0 does not work for me, why I don't know.

Help and advice, please.

Thanks in advance.

Ethan

MySQL 5.1 PHP 5 Linux [Debian (sid)]


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux