Change start point of auto increment value for a mysql table from PhpmyAdmin

Abdul AwalArticles, Web DevelopmentLeave a Comment

In some cases you may need to start auto increment value of a table in mysql database. I am going to share a very simple way to do that here.

  1. Open phpmyadmin and click on the Database name from left bar.
  2. Now, once you have the Database open, click on SQL on top menu.
  3. Put the following line in the textarea:
ALTER TABLE table_name AUTO_INCREMENT = 19005;

Click on go and you’re done…!

sql sql_insert

Abdul AwalChange start point of auto increment value for a mysql table from PhpmyAdmin

Leave a Reply

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