MySQL ERROR 1062:alter TABLE causes auto_increment Resequen

The following error is reported when I try to modify the primary key of the MySQL data table with Navicat to automatically grow

1602 ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ' 1′for key ' PRIMARY '

Workaround:

1th Step: Change the value of the primary key field to 0 for any number that is greater than 0 and does not repeat

2nd Step: Modify the primary key field Auto_increment

3rd Step: Restore the value of the record that you just modified

From: http://blog.sina.com.cn/s/blog_625977810100xwfi.html

MySQL ERROR 1062:alter TABLE causes auto_increment Resequen