DML
2.
给出相应的INSERT语句来完成题中给出数据的插入。
命令：
insert into Student values(5001,'李勇','男','1987-7-22',95001);
insert into Student values(5002,'刘晨','女','1987-11-15',95002);
insert into Student values(5003,'王敏','女','1987-10-5',95001);
insert into Student values(5004,'李好尚','男','1987-9-25',95003);
insert into Student values(5005,'李军','男','1987-7-17',95004);
insert into Student values(5006,'范新位','女','1987-6-18',95005);
insert into Student values(5007,'张霞东','女','1987-8-29',95006);
insert into Student values(5008,'赵薇','男','1987-6-15',95007);
insert into Student values(5009,'钱民将','女','1987-6-23',95008);
insert into Student values(5010,'孙俪','女','1987-9-24',95002);
insert into Student values(108,'赵里','男','1987-6-15',95007);
insert into Student values(109,'丘处机','男','1987-6-23',95008);
insert into Student values(107,'杨康','男','1987-9-24',95001);
insert into Teacher values(1,'李卫','男','1957-11-5','教授','电子工程系');
insert into Teacher values(2,'刘备','男','1967-10-9','副教授','math');
insert into Teacher values(3,'关羽','男','1977-9-20','讲师','sc');
insert into Teacher values(4,'李修','男','1957-6-25','教授','elec');
insert into Teacher values(5,'诸葛亮','男','1977-6-15','教授','计算机系');
insert into Teacher values(6,'殷素素','女','1967-1-5','副教授','sc');
insert into Teacher values(7,'周芷若','女','1947-2-23','教授','sc');
insert into Teacher values(8,'赵云','男','1980-6-13','副教授','计算机系');
insert into Teacher values(9,'张敏','女','1985-5-5','助教','sc');
insert into Teacher values(10,'黄蓉','女','1967-3-22','副教授','sc');
insert into Teacher values(11,'张三','男','1967-3-22','副教授','sc');
insert into Course values('3-101','数据库',1);
insert into Course values('5-102','数学',2);
insert into Course values('3-103','信息系统',3);
insert into Course values('3-104','操作系统',4);
insert into Course values('3-105','数据结构',5);
insert into Course values('3-106','数据处理',5);
insert into Course values('4-107','pascal语言',6);
insert into Course values('4-108','C++',7);
insert into Course values('4-109','java',8);
insert into Course values('3-245','数据挖掘',10);
insert into Course values('3-111','软件工程',11);
insert into Score values(5001,'3-105',69);
评论0