首页 > mysql 1对1关系求助!

mysql 1对1关系求助!

CREATE TABLE instructor(iName CHAR(10) NOT NULL, ins_id INTEGER PRIMARY KEY)ENGINE=InnoDB;
INSERT INTO instructor(iName,ins_id) VALUES("Paul",1),("Matt",2);
CREATE TABLE teaching_team(cName CHAR(10) NOT NULL,c_id INTEGER PRIMARY KEY)ENGINE=InnoDB;
INSERT INTO teaching_team VALUES("Math",1),("Music",2);
CREATE TABLE courses(
cName CHAR(20),
c_id INTEGER PRIMARY KEY,
    FOREIGN KEY (c_id),
    REFERENCES teaching_team (c_id)
    ON UPDATE CASCADE
    ON DELETE CASCADE
)ENGINE=InnoDB;

现在就是courses和teaching_team是一对一的关系,但是报错,说:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
    REFERENCES teaching_team (c_id)
    ON UPDATE CASCADE
    ON DELETE CASCADE
)ENGINE='

我检查不出来啊!!!


貌似references前面的逗号多了

【热门文章】
【热门文章】