IT & Programming

Set auto increment number for mysql table

Sometimes you need to set the next auto increment value in mysql database table where data already exists. This simple line of script can be run via mysql console or phpMyAdmin.

ALTER TABLE table_name AUTO_INCREMENT = 25

Leave A comment

Email address is optional and will not be published. Only add email address if you want a reply from blog author.
Please fill required fields marked with *