mysql error1215
来源:互联网 发布:windows如何录屏 编辑:程序博客网 时间:2024/06/03 21:09
You have a foreign key constraint operating in both directions. When you're creating the tables the first to be created will fail because the second doesn't exist. I'm not even sure that MySQL will accept a circular reference like this. You should probably remove the foreign key constraint applied to mydb.store
However, if this is essential you can ask MySQL to ignore the foreign key checks while you create the table. Just execute
SET foreign_key_checks = 0;
before you create the tables and
SET foreign_key_checks = 1;
after you finish
0 0
- mysql error1215
- Mysql
- MySql
- MYSQL
- MySQL
- mysql
- mysql
- mysql
- mysql
- Mysql
- Mysql
- mysql
- MySQL
- mysql
- Mysql
- mysql
- mysql
- mysql
- iOS中内存初级管理
- mysql更改数据库引擎
- MySQL 集群
- 10 桥接模式(Bridge)
- 百度地图+Marker纠偏
- mysql error1215
- Mysql备份还原数据库之mysqldump实例及参数详细说明
- Spring 事务相关
- opencv (centos and ubuntu)
- java枚举类Enum方法简介(valueof,value,ordinal)
- IOS中Json解析的四种方法
- linux下hadoop运行的几个管理界面网址
- 虚拟机、linux系统安装
- java枚举使用详解