主键重排

方式一：

  1. alter table table_name drop id;
  2. alter table table_name add id bigint(20) primary key auto_increment first;

方式二：

  1. alter table table_name AUTO_INCREMENT = 0

重新设置主键值

  1. alter table table_name AUTO_INCREMENT = 1;

查询重复数据

  1. select * from table_name where field 
  2. in (select field from table_name group by field having count(field) > 1);