If you liked this site, please feel free to help me out with the upkeep!

Get Firefox!

Valid HTML 4.01 Transitional

Home > Programming > MySQL - Resetting auto_increment

Many times when testing data written to a table during code development I have needed to reset auto_increment back to zero, but I always forget the syntax, so here it is...

ALTER TABLE tbl_name AUTO_INCREMENT = 0