Mysql create table Error:1005
来源:互联网 发布:物理仿真实验室软件 编辑:程序博客网 时间:2024/06/08 15:47
I realize this is an old post, but it ranks high in Google, so I'm adding what I figured out for MY problem. If you have a mix of table types (e.g. MyISAM and InnoDB), you will get this error as well. In this case, InnoDB is the default table type, but one table needed fulltext searching so it was migrated to MyISAM. In this situation, you cannot create a foreign key in the InnoDB table that references the MyISAM table.
这是一个问题,也就是说需要添加成
Create table sentiment_April(
id int primary key auto_increment,
sentiment float ,
tweet_id bigint(20),
CONSTRAINT fk_PerOrders FOREIGN KEY (tweet_id)
REFERENCES tweets_April(tweet_id)
)ENGINE=MyISAM;
或者
Create table sentiment_April(
id int primary key auto_increment,
sentiment float ,
tweet_id bigint(20),
CONSTRAINT fk_PerOrders FOREIGN KEY (tweet_id)
REFERENCES tweets_April(tweet_id)
)ENGINE=InnoDB;
- Mysql create table Error:1005
- MYSQL ERROR 1005:cannot create table 解决方案
- mysql ERROR: Error 1005: Can't create table (errno: 121)
- Mysql create table failure: ERROR 1005 (HY000): Can't create table 'lams.attendance1' (errno: 121)
- mysql 创建外键:ERROR 1005: Can't create table
- mysql 创建外键:ERROR 1005: Can't create table
- MySQL ERROR 1005: Can't create table (errno: 150)解决办法
- MySQL ERROR 1005: Can't create table (errno: 150)解
- MySQL ERROR 1005: Can't create table (errno: 150)
- MYSQL中ERROR 1005 (HY000): Can't create table 错误
- MySQL ERROR 1005: Can't create table (errno: 150)解决办法
- MySQL ERROR 1005: Can't create table (errno: 150)
- MySQL ERROR 1005: Can't create table (errno: 150)
- MySql innodb 出错: Error Code: 1005 Can't create table
- MySQL ERROR 1005: Can’t create table (errno: 150)解决办法
- MySQL ERROR 1005: Can't create table (errno: 150)解决办法
- MySQL ERROR 1005: Can't create table (errno: 150)解决办法
- MySQL ERROR 1005: Can't create table 分析
- LeetCode算法编程 - Palindrome Partitioning
- LeetCode算法编程 - Palindrome Partitioning
- LeetCode算法编程 - Palindrome Partitioning
- 教书匠杂感
- Linux 学习 CD命令
- Mysql create table Error:1005
- excel如何生成各种图
- eccube网站制作中常见问题
- 程序员的智囊库系列之1--服务器与运维
- 程序员的智囊库系列之1--服务器与运维
- 程序员的智囊库系列之1--服务器与运维
- 程序员的智囊库系列之1--服务器与运维
- 程序员的智囊库系列之1--服务器与运维
- tomcat正常启动,连接不上8080