MySQL的數據庫drop不了Cannot delete or update a parent row: a foreign key constraint fails
来源:互联网 发布:html源码怎么安装 编辑:程序博客网 时间:2024/06/05 04:14
MySQL的數據庫drop不了, 出現以下message, 可以試下 SET FOREIGN_KEY_CHECKS = 0;
mysql> drop database myDB;
ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint failsmysql> SET FOREIGN_KEY_CHECKS = 0;drop database myDB;
Query OK, 0 rows affected (0.00 sec)
Query OK, 4 rows affected (0.01 sec)
- 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
- 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: 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
- #1451 - Cannot delete or update a parent row: a foreign key constraint fails 问题的解决办法
- 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
- 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” 异常解决
- VIM的几个使用技巧
- python 解析线性方程组
- 一些hadoop分析的文章链接
- 【翻译】两种高性能I/O设计模式(Reactor/Proactor)的比较
- 在Heroku上部署Java应用三步曲
- MySQL的數據庫drop不了Cannot delete or update a parent row: a foreign key constraint fails
- EXTJS4和JQuery选择器比较
- Hadoop、Pig、Hive、NOSQL 学习资源收集
- UVa 540 - Team Queue
- Boundary Traversal of binary tree
- Boundary Traversal of binary tree
- ubuntu 的新生活
- 使用SQL Server Analysis Services数据挖掘的关联规则实现商品推荐功能(一)
- 大战2013之六:解决3DSMax右手坐标系转换左手坐标系的问题