添加数据内容/记录

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','电子信息工程','上海市浦东区'),

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

#查看数据内容/记录

select * from studentinfo;

insert into courseinfo

values

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

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

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

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

('1025','英语',3);

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','86'),

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

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

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

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

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

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

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

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

('184003','1201','94');

insert into teacherinfo

values

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

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

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

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

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