How to Change Autoincriment Value in MySQL

If you have a attribute in your table that automatically increments itself for every new row, you can change what the next value is very easily.

You can do so by either of the two following ways.

1. Change the autoincrement value with a simple sql query.

ALTER TABLE {table name} AUTO_INCREMENT = {some number};

Where {table name} is the name of the table of which you are modifying the auto_increment value and {some number} is the actual auto_increment attribute value that you wish the next row to have.

2. When inserting the next row in that table, manually set the value for the auto_increment attribute and it will automatically continue from that number for future entries.