mysql外键约束删除数据问题

背景

在删除有外键的数据库表经常会出现错误，提示有外键约束

解决办法：

   1：常规

按照提示的消息一条一条找过去，找到最小的一条，然后倒着删除如:

mysql> delete from base_operation where id='4028db8144881f0e01448830a3070020';
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`gd_sox_test`.`base_role_operation`, CONSTRAINT `fk_reference_12` FOREIGN KEY (`operation_id`) REFERENCES `base_operation` (`id`))
mysql> delete from base_operation where id='4028db8144881f0e01448830a3070020';
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`gd_sox_test`.`base_role_operation`, CONSTRAINT `fk_reference_12` FOREIGN KEY (`operation_id`) REFERENCES `base_operation` (`id`))
mysql> delete from base_role_operation ^C

。。。

mysql> delete from base_role_operation where operation_id='4028db8144881f0e01448830a3070020';
Query OK, 1 row affected (0.01 sec)

mysql> delete from base_operation where id='4028db8144881f0e01448830a3070020';
Query OK, 1 row affected (0.01 sec)

mysql> delete from base_module where id='4028db8144881f0e0144883098de001f';

图中：省略查找的过程，

2：暴力删除，去掉mysql的外键约束可以直接删除

禁用外键约束
SET FOREIGN_KEY_CHECKS=0;

--进行删除

启动外键约束
SET FOREIGN_KEY_CHECKS=1;
查看当前FOREIGN_KEY_CHECKS的值
SELECT  @@FOREIGN_KEY_CHECKS;