2020/10/30 刘一辰的JAVA随笔

今日目标：Mysql学习6

实验内容：

向表中添加数据

 

--学生表数据

INSERT INTO student VALUES('101','曾华','男','1977-09-01','95033');

INSERT INTO student VALUES('102','匡明','男','1975-10-02','95031');

INSERT INTO student VALUES('103','王丽','女','1976-01-23','95033');

INSERT INTO student VALUES('104','李军','男','1976-02-20','95033');

INSERT INTO student VALUES('105','王芳','女','1975-02-10','95031');

INSERT INTO student VALUES('106','陆军','男','1974-06-03','95031');

INSERT INTO student VALUES('107','王尼玛','男','1976-02-20','95033');

INSERT INTO student VALUES('108','张全蛋','男','1975-02-10','95031');

INSERT INTO student VALUES('109','赵铁柱','男','1974-06-03','95031');

 

--教师表数据

INSERT INTO teacher VALUES('804','李诚','男','1958-12-02','副教授','计算机系');

INSERT INTO teacher VALUES('856','张旭','男','1969-03-12','讲师','电子工程系');

INSERT INTO teacher VALUES('825','王萍','女','1972-05-05','助教','计算机系');

INSERT INTO teacher VALUES('831','刘冰','女','1977-08-14','助教','电子工程系');

 

--添加课程表

INSERT INTO course VALUES('3-105','计算机导论','825');

INSERT INTO course VALUES('3-245','操作系统','804');

INSERT INTO course VALUES('6-166','数字电路','856');

INSERT INTO course VALUES('9-888','高等数学','831');

 

--添加成绩表

INSERT INTO score VALUES('103','3-245','86');

INSERT INTO score VALUES('105','3-245','75');

INSERT INTO score VALUES('109','3-245','68');

INSERT INTO score VALUES('103','3-105','92');

 

INSERT INTO score VALUES('105','3-105','88');

INSERT INTO score VALUES('109','3-105','76');

INSERT INTO score VALUES('103','6-166','85');

 

INSERT INTO score VALUES('105','6-166','79');

INSERT INTO score VALUES('109','6-166','81');