,

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

Changing the auto increment value in phpMyAdmin

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 Awal Uzzal
Written byAbdul Awal Uzzal

Tech entrepreneur and AI-first founder. I lead the team behind ThemeNcode, TNCFlow and TNC FlipBook.

Get in touch

One response to “Change start point of auto increment value for a mysql table from PhpmyAdmin”

  1. Morten

    Getting this in respons:

    #1067 – Invalid default value for ‘post_date’