34,575
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO COURSE VALUES ('2','数学',NULL,4)
INSERT INTO COURSE VALUES ('6','数据处理',NULL,2)
INSERT INTO COURSE VALUES ('4','操作系统','6',3)
INSERT INTO COURSE VALUES ('7','PASCAL语言','6',4)
INSERT INTO COURSE VALUES ('5','数据结构','7',4)
INSERT INTO COURSE VALUES ('1','数据库','5',4)
INSERT INTO COURSE VALUES ('3','信息系统','1',4)
或先输空值,然后调整
INSERT INTO COURSE VALUES ('1','数据库',NULL,4)
INSERT INTO COURSE VALUES ('2','数学',NULL,4)
INSERT INTO COURSE VALUES ('3','信息系统',NULL,4)
INSERT INTO COURSE VALUES ('4','操作系统',NULL,3)
INSERT INTO COURSE VALUES ('5','数据结构',NULL,4)
INSERT INTO COURSE VALUES ('6','数据处理',NULL,2)
INSERT INTO COURSE VALUES ('7','PASCAL语言',NULL,4)
UPDATE COURSE SET CPNO='5' WHERE CNO='1'
UPDATE COURSE SET CPNO='1' WHERE CNO='3'
UPDATE COURSE SET CPNO='6' WHERE CNO='4'
UPDATE COURSE SET CPNO='7' WHERE CNO='5'
UPDATE COURSE SET CPNO='6' WHERE CNO='7'