PDA

View Full Version : re-setting auto_increment

phpPete
03-07-02, 12:26
After some testing I'll be deleting all the data from a number of tables. How does one re-set the auto_increment index back to 0 ?
phpPete
03-07-02, 12:29
Drum roll please...

answer is:

ALTER TABLE tbl_name AUTO_INCREMENT = 1;

Pretty straight forward