mySQL reset auto_increment
| From: | Jon Shoberg | Date: | Mon, 02 Jul 2001 23:15:27 +0000 |
| Subject: | mySQL reset auto_increment | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-55909@lists.php.net to get a copy of this message | ||
Is there an SQL query for resetting the autoincrement field of a table ? I
know myisamchk will do this but the system I am on will not let me us it. I
can get console level access but that is all. I simply want to reindex my
data back to the start of 1.
Thanks