学生信息数据库（stusys）的样本数据填充（p307-308)

1. 填充表student

命令:

mysql> use stusys;

mysql> insert into student

-> values

-> ('191001','刘清泉','男','1998-06-21','计算机',52),

-> ('191002','张慧玲','女','1999-11-07','计算机',50),

-> ('191003','冯涛','男','1999-08-12','计算机',52),

-> ('196001','董明霞','女','1999-05-02','通信',50),

-> ('196002','李茜','女','1998-07-25','通信',48),

-> ('196004','周俊文','男','1998-03-10','通信',52);

mysql> select * from student;

2. 填充表course

命令:

mysql> use stusys;

mysql> insert into course

-> values

-> ('1004','数据库系统',4),

-> ('1017','操作系统',3),

-> ('4002','数字电路',3),

-> ('8001','高等数学',4),

-> ('1201','英语',4);

mysql> select * from course;

3. 填充表score

命令:

mysql> use stusys;

mysql> insert into score

-> values

-> ('191001','1004','95'),

-> ('191002','1004','87'),

-> ('191003','1004','93'),

-> ('196001','4002','90'),

-> ('196002','4002','79'),

-> ('196004','4002','88'),

-> ('191001','8001','92'),

-> ('191002','8001','88'),

-> ('191003','8001','84'),

-> ('196001','8001','87'),

-> ('196002','8001',null),

-> ('196004','8001','94'),

-> ('191001','1201','92'),

-> ('191002','1201','78'),

-> ('191003','1201','93'),

-> ('196001','1201','84'),

-> ('196002','1201','76'),

-> ('196004','1201','92');

mysql> select * from score;

4. 填充表teacher

命令:

mysql> use stusys;

mysql> insert into teacher

-> values

-> ('100006','何艺杰','男','1970-06-23','教授','计算机学院'),

-> ('100023','孙浩然','男','1979-04-09','教授','计算机学院'),

-> ('400017','李亚兰','女','1988-11-04','讲师','通信学院'),

-> ('800028','袁万明','男','1978-08-15','副教授','数学学院'),

-> ('120046','刘颖','女','1976-12-15','副教授','外国语学院');

mysql> select * from teacher;

5. 填充表lecture

命令:

mysql> use stusys;

mysql> insert into lecture

-> values

-> ('100006','1004','2-311'),

-> ('400017','4002','1-106'),

-> ('800028','8001','6-104'),

-> ('120046','1201','6-215');

mysql> select * from lecture;