1.主键
添加:
alter table table_name add primary key(`column`)
删除:
alter table table_name drop primary key
2.唯一索引
添加:
alter table table_name add unique index(`column`)
删除:
alter table table_name drop index `column`
1.主键
添加:
alter table table_name add primary key(`column`)
删除:
alter table table_name drop primary key
2.唯一索引
添加:
alter table table_name add unique index(`column`)
删除:
alter table table_name drop index `column`