STUDENT_COURSE DATABASE——(TABLE)STU_SINGLE
#创建学生—单局项目得分表,并在其中引用学生表的学号,项目表的项目编号,并对二者进行级联操作 CREATE TABLE STU_SINGLE( ID INT AUTO_INCREMENT NOT NULL, PRIMARY KEY(ID), SNO VARCHAR(225), PNO VARCHAR(225), SINGLEGRADE INT, DATES DATE, RIVAL VARCHAR(225), RESULTS VARCHAR(225), FOREIGN KEY (SNO) REFERENCES STU_INFORMATION(SNO) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (PNO) REFERENCES PRO_INFORMATION(PNO) ON DELETE CASCADE ON UPDATE CASCADE ); #检查学生-项目-单局得分表 SELECT ID 序号,SNO 学号,PNO 项目号,SINGLEGRADE 单局得分,DATES 日期,RIVAL 对手,RESULTS 输赢 FROM STU_SINGLE;优质内容筛选与推荐>>