+-----------+-------+------+------+-------+
-- 课程表，记录课程信息，cpno是指当前记录的先行课程的cno
CREATE TABLE course(
cno INT AUTO_INCREMENT,
cname VARCHAR(10),
cpno INT,
ccredit INT NOT NULL,
PRIMARY KEY(cno),
FOREIGN KEY(cpno) REFERENCES course(cno)
);
+-----------+-------+------+------+-------+
(北联网教程,专业提供视频软件下载)
……