MySQL: change table auto increment value

If you need to change current value of auto_increment for table you could use the following SQL query:

ALTER TABLE `table_name` AUTO_INCREMENT=1001;

Leave a Reply

Your email address will not be published. Required fields are marked *