如何在一个表中创建两个外键,
CREATE TABLE SC(
-> Sno int NOT NULL PRIMARY KEY AUTO_INCREMENT,
-> Cno int NOT NULL,
-> Grade int NOT NULL,
-> SSno int NOT NULL,
-> CCno int NOT NULL,
-> FOREIGN KEY (SSno) REFERENCES Student (Sno),
-> FOREIGN KEY (CCno) REFERENCES Course (CCno)
-> );