MySql 错误 150 - 外键

问题描述

当我执行以下两个查询时(我已经将它们精简到绝对必要):

When I execute the follow two queries (I have stripped them down to absolutely necessary):

mysql> CREATE TABLE foo(id INT PRIMARY KEY);
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE bar ( id INT, ref INT, FOREIGN KEY (ref) REFERENCES foo(id)) ENGINE InnoDB;

我收到以下错误:错误 1005 (HY000): 无法创建表 './test/bar.frm' (errno: 150)

I get the following error: ERROR 1005 (HY000): Can't create table './test/bar.frm' (errno: 150)

我的错误在哪里?盯着这个看了半个小时都没找到.

Where the **** is my error? I haven't found him while staring at this for half an hour.

推荐答案

来自 外键约束

如果你重新创建一个表删除，它必须有一个定义符合外键的引用它的约束.它必须有正确的列名和类型，并且它必须有索引引用的键，如前所述.如果这些不满足，MySQL返回错误编号 1005 并指错误错误消息中的 150.

If you re-create a table that was dropped, it must have a definition that conforms to the foreign key constraints referencing it. It must have the right column names and types, and it must have indexes on the referenced keys, as stated earlier. If these are not satisfied, MySQL returns error number 1005 and refers to error 150 in the error message.

我怀疑是因为您没有将 foo 创建为 InnoDB，因为其他一切看起来都不错.

My suspicion is that it's because you didn't create foo as InnoDB, as everything else looks OK.

来自同一页面 -

两个表都必须是 InnoDB 表并且它们不能是 TEMPORARY 表.

Both tables must be InnoDB tables and they must not be TEMPORARY tables.

这篇关于MySql 错误 150 - 外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！