[MySQL][Resolved] Change auto increment value in mysql

You can change the SQL statement shown below, change the word in red to your text::

ALTER TABLE your_table_name AUTO_INCREMENT = your_new_index_num

My case:

ALTER TABLE stat_years AUTO_INCREMENT = 2

Result:

Reference:
http://stackoverflow.com/questions/970597/change-auto-increment-starting-number