Change current auto increment
If you need to wind back an auto increment, or begin counting from some arbitrary starting point after the table has been defined
ALTER TABLE table AUTO_INCREMENT = 100;
If you need to wind back an auto increment, or begin counting from some arbitrary starting point after the table has been defined
ALTER TABLE table AUTO_INCREMENT = 100;