Modify the auto increment value in mySQL

If you want to modify the auto increment column to start inserting records from a specific value then you will need to run the following statement.

ALTER TABLE <table_name> AUTO_INCREMENT = 12345;

After running the above statement the insertion will start from that value. However if there are any records which have a value greater than 12345 then the next record will start from 12345 + 1 = 12346

Hope the above helps

Leave a Comment