Because I keep forgetting it: ALTER TABLE the_table AUTO_INCREMENT= 0
MySQL reset auto_increment
6th Sep 2009
Because I keep forgetting it: ALTER TABLE the_table AUTO_INCREMENT= 0