数据库主键id重新排序方法

alter table user drop id;alter table user add id int(3) not null first;alter table user modify column id int( 3 ) not nullauto_increment,add primary key(id);

炸了毛的猫

2226人浏览 · 2020-01-16 16:33:52

炸了毛的猫 · 2020-01-16 16:33:52 发布

  alter table user drop id;
  alter table user add id int(3) not null first;
  alter table user modify column id int( 3 ) not null auto_increment,add primary key(id);
第二种方法
alter table t_order drop id;
alter table t_order add id int(11) primary key auto_increment first;