数据库p88-表格代码mysql

#81-例5.4

use stuexpm;

insert into studentInfo

values

('181001','成志强','男','1998-08-17','计算机','北京市海淀区'),

('181002','孙红梅','女','1997-11-23','计算机','成都市锦江区'),

('181003','朱丽','女','1998-02-19','计算机','北京市海淀区'),

('184001','王智勇','男','1997-12-05','电子信息工程','null'),

('184002','周潞潞','女','1998-02-24','电子信息工程','上海市浦东区'),

('184003','郑永波','男','1997-09-19','电子信息工程','上海市浦东区');

#查看数据表

select * from studentInfo;

例5.2

use stuexpm;

insert into CourseInfo

values

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

('1025','物联网技术','3'),

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

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

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

select * from CourseInfo;

#5.3

use stuexpm;

insert into ScoreInfo

values

('181001','1004','95'),

('181002','1004','85'),

('181003','1004','91'),

('184001','4002','93'),

('184002','4002','76'),

('184004','4002','88'),

('181001','8001','94'),

('181002','8001','89'),

('181003','8001','96'),

('184001','8001','85'),

('184002','8001',null),

('184004','8001','94'),

('181001','1201','92'),

('181002','1201','78'),

('181003','1201','94'),

('184001','1201','85'),

('184002','1201','79'),

('184004','1201','94');

select * from ScoreInfo;

#5.4

use stuexpm;

insert into TeacherInfo

values

('100005','李慧强','男','1968-09-25','计算机学院','北京市海淀区'),

('100024','刘松','男','1976-02-17','计算机学院','北京市海淀区'),

('400021','陈霞飞','女','1975-12-07','通信学院','上海市黄浦区'),

('800004','刘泉明','男','1978-08-16','数学学院','广州市越秀区'),

('120007','张莉','女','1982-03-21','外国语学院','成都市锦江区');

select * from TeacherInfo;