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前面的逗号多了