insert.sql

来自「数据库平台 sql的一些基本语句对数据库可以进行修改 删除 插入 等 操作」· SQL 代码 · 共 59 行

INSERT INTO S
VALUES('S1','WANG',20,'M');
INSERT INTO S
VALUES('S2','LIU',20,'M');
INSERT INTO S
VALUES('S3','CHEN',22,'M');
INSERT INTO S
VALUES('S4','WU',19,'M');
INSERT INTO S
VALUES('S5','LOU',21,'F');
INSERT INTO S
VALUES('S6','DONG',18,'F');

INSERT INTO C
VALUES('C1','DB','LI');
INSERT INTO C
VALUES('C2','MATHS','MA');
INSERT INTO C
VALUES('C3','CHEMISTRY', 'ZHOU');
INSERT INTO C
VALUES('C4','PHYSICS','SHI');
INSERT INTO C
VALUES('C5','OS','WEN');

INSERT INTO SC
VALUES('S1','C1','80');
INSERT INTO SC
VALUES('S1','C2','70');
INSERT INTO SC
VALUES('S1','C3','85');
INSERT INTO SC
VALUES('S1','C4','90');
INSERT INTO SC
VALUES('S1','C5','70');
INSERT INTO SC
VALUES('S2','C1','85');
INSERT INTO SC
VALUES('S3','C1','90');
INSERT INTO SC
VALUES('S3','C2','85');
INSERT INTO SC
VALUES('S3','C3','95');
INSERT INTO SC
VALUES('S4','C1','75');
INSERT INTO SC
VALUES('S4','C4','70');
INSERT INTO SC
VALUES('S5','C1','70');
INSERT INTO SC
VALUES('S5','C2','60');
INSERT INTO SC
VALUES('S5','C3','80');
INSERT INTO SC
VALUES('S5','C5','65');
INSERT INTO SC
VALUES('S6','C1','90');
INSERT INTO SC
VALUES('S6','C3','95');