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 … Read moreModify the auto increment value in mySQL