执行sql语句时
Cannot delete or update a parent row: a foreign key constraint fails (`function`, CONSTRAINT `function_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `function` (`id`))
这时候执行一下
SET FOREIGN_KEY_CHECKS=0;
在执行sql语句
执行sql语句时
Cannot delete or update a parent row: a foreign key constraint fails (`function`, CONSTRAINT `function_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `function` (`id`))
这时候执行一下
SET FOREIGN_KEY_CHECKS=0;
在执行sql语句