- mysql表字段添加主键:
- alter table user add primary key(id);
- alter table user change id id int(10) not null auto_increment;
- mysql删除表字段主键:
- alter table user change id id int(10); //先删除自增长
- alter table user drop primary key; //再删除主键
mysql 添加/删除主键
最新推荐文章于 2023-09-21 21:59:09 发布