show create table 数据表名;找到CONSTRAINT `外键名` FOREIGN KEY (`xxxx`) REFERENCES `xxxxxx` (`id`)alter table drop foreign key 外键名; 注意:跟主动设定的item名不一致