Reset MySQL Auto Increment Value
September 16th, 2009ALTER TABLE `tablename` AUTO_INCREMENT =0
Will reset the auto_increment to the lowest value in the table.
ALTER TABLE `tablename` AUTO_INCREMENT =0
Will reset the auto_increment to the lowest value in the table.