Set auto-increment field value in MySQLPosted: May 21, 2017
You have a table. The table has a primary key auto-increment numeric ID field. You want to fast-forward the ID to a certain value (which is larger than or equal to the last value the field has).
Example, let the ID of the next entered record be 1000:
ALTER TABLE `mytable` AUTO_INCREMENT = 1000;