mysql drop table 出现 Cannot delete or update a parent row:
来源:互联网 发布:java工程师和架构师 编辑:程序博客网 时间:2024/06/06 14:16
当在Mysql下删除有一个建有外键的表的数据时可能会报此异常,所以可以启动MySql命令行模式,运行如下的sql语句来关闭外键检测:
SET FOREIGN_KEY_CHECKS = 0;
执行你要的操作后把再把外键检测恢复
SET FOREIGN_KEY_CHECKS = 1;
其他相关的有:
关闭唯一性校验
set unique_checks=0;
set unique_checks=1;
原文:点击打开链接
0 0
- mysql drop table 出现 Cannot delete or update a parent row:
- mysql 出现Cannot delete or update a parent row:
- Cannot delete or update a parent row
- MySQL的數據庫drop不了Cannot delete or update a parent row: a foreign key constraint fails
- [MySQL]MYSQL: Cannot delete or update a parent row: a foreign key constraint fails
- 待解决,Cannot delete or update a parent row
- MYSQL "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
- MYSQL: Cannot delete or update a parent row: a foreign key constraint fails
- MySQL error code 1217 (ER_ROW_IS_REFERENCED): Cannot delete or update a parent row: a foreign key co
- MYSQL: 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
- MYSQL: 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
- MYSQL: 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
- MySQL:ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
- error:mysql删除报错Cannot delete or update a parent row (201
- Android数字动态显示,仿支付宝app效果简单的实现。字数从0-x!!!
- 04-树4 是否同一棵二叉搜索树
- Linux静态IP及DNS配置
- 进程&进程间通信
- POJ 2175 Evacuation Plan 费用流消圈算法
- mysql drop table 出现 Cannot delete or update a parent row:
- Android 点击
- HDU 3263 (平面几何)
- 函数笔记
- poj1062昂贵的聘礼(题解)最短路
- Android简易实战教程--第十五话《在外部存储中读写文件》
- 设置(创建)主键和外键的三种方式 和 删除含有主键外键的表顺序
- 定时器中的this指向问题
- 打印、注释、打印中文