mysql重置主键id

1.先删除主键

2.新增主键id

alter table table_name drop id;

alter table table_name add id bigint(20) not null primary key auto_increment first;