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
If you liked this site, please feel free to help me out with the upkeep!
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...
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...