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