Resetting auto_increment
| From: | Ethan Rosenberg | Date: | Tue, 14 Dec 2010 17:34:52 +0000 |
| Subject: | Resetting auto_increment | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47534@lists.php.net to get a copy of this message | ||
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)]