MySQL建表后无法添加外键约束

Question

这个问题已经有答案了:

MySQL Creating tables with Foreign Keys giving errno: 150 (20 个回答)

已关闭 3 年前。

我不确定以下 MySQL 语句有什么问题。我已经创建了每个表，但是在运行以下语句时出现错误:

Error Code: 1215. Cannot add foreign key constraint

MySQL 语句:

/**
CREATE TABLE Episodes (
    season INT,
    num INT,
    title VARCHAR(50),
    director VARCHAR(50),
    viewers DECIMAL(2, 1),
    PRIMARY KEY (season, num)
);

CREATE TABLE Characters (
    name VARCHAR(50),
    house VARCHAR(50),
    PRIMARY KEY (name)
);
**/
CREATE TABLE Appearances (
    name VARCHAR(50),
    season VARCHAR(50),
    num INT,
    PRIMARY KEY (name, season, num),
    FOREIGN KEY (name) REFERENCES Characters(name),
    FOREIGN KEY (season) REFERENCES Episodes(season)
);

我在这里做错了什么？

Answer 1

愚蠢的错误，我与season的类型不一致。将 season 更改为 INT 类型修复了此错误。