mysql - 错误1005(HY000): Can't create table 'test.sports' (errno: 150)

Question

抛出错误:

ERROR 1005 (HY000): Can't create table 'test.sports' (errno: 150).

我需要帮助来解决这个问题。

 CREATE TABLE sports(
-> interest text,
-> prize_money int,
-> sp_id int NOT NULL,
-> CONSTRAINT fk_sports 
-> FOREIGN KEY(sp_id)
-> REFERENCES records(id)
-> ON DELETE CASCADE
-> ON UPDATE CASCADE
-> ) ENGINE=INNODB;

Answer 1

您的records 表没有名为id 的列。相反，它的主键列是 student_id，因此您可能打算从 sports 中的外键引用它。试试这个定义:

CREATE TABLE sports(
    interest text,
    prize_money int,
    sp_id int NOT NULL,
    CONSTRAINT fk_sports 
    FOREIGN KEY(sp_id)
    REFERENCES records(student_id)
    ON DELETE CASCADE
    ON UPDATE CASCADE
) ENGINE=INNODB;