关闭外键检查 ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
来源:互联网 发布:天猫童装数据 编辑:程序博客网 时间:2024/05/16 23:51
由于连个表之间有外键制约,所以无法删除
可以通过关闭数据库的外键检查功能来解决该问题,
mysql> SET FOREIGN_KEY_CHECKS=0;
之后再将外键检查功能打开
mysql> SET FOREIGN_KEY_CHECKS=1;
- 关闭外键检查 ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails...问题解决
- ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- MySQL:ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- MySQL错误号1451-Cannot delete or update a parent row: a foreign key constraint fails
- #1451 - Cannot delete or update a parent row: a foreign key constraint fails 问题的解决办法
- #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`shop`.`orders`, CONST
- ERROR 1217 (23000) at line 19: Cannot delete or update a parent row: a foreign key constraint fails
- Cannot delete or update a parent row: a foreign key constraint fails
- MYSQL "Cannot delete or update a parent row: a foreign key constraint fails "
- jbpm Cannot delete or update a parent row: a foreign key constraint fails
- Cannot delete or update a parent row: a foreign key constraint fails
- MYSQL: Cannot delete or update a parent row: a foreign key constraint fails
- Cannot delete or update a parent row: a foreign key constraint fails
- jbpm4 jbpm4_execution “Cannot delete or update a parent row: a foreign key constraint fails” 异常解决
- Cannot delete or update a parent row: a foreign key constraint fails
- Cannot delete or update a parent row: a foreign key constraint fails解决方法
- NSIS官网 http://nsis.sourceforge.net
- 开源网店系统Javashop 发布3.0beta版
- 最牛B 的 Linux Shell 命令, SHell使用技巧
- nova-network 固定IP的释放
- 矩阵的应用--矩阵相乘与矩阵快速幂
- 关闭外键检查 ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- 多态的概念和作用
- function &instance(){} &是什么意思?
- linux c/c++ 直接使用底层系统调用效率低
- page208-19
- OGRE程序加载mesh文件原理
- PAGE208_19
- asp.net2.0 gridview空数据时 仅显示列头
- 多态