在删除主表数据时,报了一个异常
Cannot delete or update a parent row: a foreign key constraint fails
原因是主表中还包含字表的数据，不能删除与这张表或数据有关联的字段，所以无法删除
解决办法：在创建数据库的外键时，将删除的动作配置由RESTRICT改成cascade，就可以解决.
相关文章
- 10-18ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails ()
- 10-18关于mysql中[Err] 1451 -Cannot delete or update a parent row: a foreign key constraint fails
- 10-18修改、删除表时候提示MySQL Cannot delete or update a parent row: a foreign key constraint fails
- 10-18mysql删除表时报错：Cannot delete or update a parent row: a foreign key constraint fails 解决办法
- 10-18MySQL：ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- 10-18表删除时 Cannot delete or update a parent row: a foreign key constraint fails 异常处理
- 10-18mysql删除有外链索引数据,Cannot delete or update a parent row: a foreign key constraint fails 问题的解决办法
- 10-18mysql 在删除数据出现Cannot delete or update a parent row: a foreign key constraint fails 这个该如何解决
- 10-18ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- 10-18Mysql - 删除表时出现： Cannot delete or update a parent row: a foreign key constraint fails