This topic is locked

How to reset autoincrement field value in MySQL

6/12/2007 1:08:00 PM
PHPRunner Tips and Tricks
Sergey Kornilov admin

Run the following in phpMyAdmin:

ALTER TABLE [tablename] AUTO_INCREMENT = [number]


where [tablename] is the name of the table and [number] is the next ID.

L
lewisekrantz 9/1/2009

you could always delete and readd the column