Monday, March 15, 2010

Reset MySQL auto increment value


ALTER TABLE tablename AUTO_INCREMENT = 1


This will reset the next auto increment value to current largest value in the auto increment column + 1.

No comments:

Post a Comment