Aug 232010
Set the auto increment start value in MySQL?
Answer:
In MySQL, you can change the table's auto increment start value by the following command.
mysql> ALTER TABLE `my_table` AUTO_INCREMENT = 2000;
Query OK, 2 rows affected (0.06 sec)
Records: 2 Duplicates: 0 Warnings: 0