Alter table causes auto_increment resequencing, resulting in duplicate entry '1' for key 'Primary ',

Alter table causes auto_increment resequencing, resulting in duplicate entry '1' for key 'Primary ',

When you open the navicat design table and want to change the primary key id to auto-increment, this prompt will pop up. Changing the table will lead to auto-increment (column) re-sorting, and the primary key will have repeated '1 '. The reason is that auto_increment is auto-incrementing from 1. If a record with id = 0 and id = 1 exists at the same time, it will change id = 0 to id = 1, so the two methods conflict.

Truncate table name and delete from tablename: the former clears data and id sorting records, and the primary key starts from 0; the suffix only clears data, do not clear the id sorting record primary key and continue accumulating from the empty position.