删除外键
alter table tablename drop foreign key keyname;
添加外键
alter table tablename add constraint foreign key(id) references parent(id);
keyname可通过 show index from tablename; 查询
删除索引
drop index keyname on tablename
alter table tablename drop foreign key keyname;
添加外键
alter table tablename add constraint foreign key(id) references parent(id);
keyname可通过 show index from tablename; 查询
删除索引
drop index keyname on tablename