auto increment for the table with 1000 of records in mysql How to reset auto increment for the table with 1000 of records in mysql. I want it to start counting from 1 again.
You can set it to 1 with this command:

mysql&gt; ALTER TABLE tbl AUTO_INCREMENT = 1;


More info in the mysql manuals, here: https://dev.mysql.com/doc/refman/5.6/en/example-auto-increment.html