#禁用外键约束
SET FOREIGN_KEY_CHECKS=0;
#进行删除
DELETE FROM 表 WHERE 条件;
#启动外键约束
SET FOREIGN_KEY_CHECKS=1;
#查看当前FOREIGN_KEY_CHECKS的值
SELECT @@FOREIGN_KEY_CHECKS;
#禁用外键约束
SET FOREIGN_KEY_CHECKS=0;
#进行删除
DELETE FROM 表 WHERE 条件;
#启动外键约束
SET FOREIGN_KEY_CHECKS=1;
#查看当前FOREIGN_KEY_CHECKS的值
SELECT @@FOREIGN_KEY_CHECKS;