auto increment for the table with 1000 of records in mysql
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