教材P54的上机练习1，result表中插入的数据为('10000','1','2016-02-15 00:00:00','71')，('10000','1','2016-02-17 00:00:00','60')，('10001','1','2016-02-17 00:00:00','46')，('10002','1','2016-02-17 00:00:00','83')，('10003','1','2016-02-17 00:00:00','60')，('10004','1','2016-02-17 00:00:00','60')，('10005','1','2016-02-17 00:00:00','95')，('10006','1','2016-02-17 00:00:00','93')，('10007','1','2016-02-17 00:00:00','23')

2022-06-18

教材P54的上机练习1，result表中插入的数据为('10000','1','2016-02-15 00:00:00','71')，('10000','1','2016-02-17 00:00:00','60')，('10001','1','2016-02-17 00:00:00','46')，('10002','1','2016-02-17 00:00:00','83')，('10003','1','2016-02-17 00:00:00','60')，('10004','1','2016-02-17 00:00:00','60')，('10005','1','2016-02-17 00:00:00','95')，('10006','1','2016-02-17 00:00:00','93')，('10007','1','2016-02-17 00:00:00','23')

答案：

*subject表数据*/ insert into subject values(1,'LogicJava',220,1),(2,'HTML',160,1),(3,'JavaOOP',230,2); [br][/br] /*student表数据*/ insert into student (studentNo, loginPwd, studentName, sex, gradeId, phone, address, bornDate, email, identityCard) values('10000','123','郭靖','男','1','13645667783','天津市河西区','1990-09-08 00:00:00',NULL,NULL)，('10001','123','李文才','男','1','13645667890','地址不详','1994-04-12 00:00:00',NULL,NULL)，('10002','123','李斯文','男','1','13645556793','河南洛阳','1993-07-23 00:00:00',NULL,NULL)，('10003','123','张萍','女','1','13642345112','地址不详','1995-06-10 00:00:00',NULL,NULL)，('10004','123','韩秋洁','女','1','13812344566','北京市海淀区','1995-07-15 00:00:00',NULL,NULL)，('10005','123','张秋丽','女','1','13567893246','北京市东城区','1994-01-17 00:00:00',NULL,NULL)，('10006','123','肖梅','女','1','13563456721','河北省石家庄市','1991-02-17 00:00:00',NULL,NULL)，('10007','123','秦洋','男','1','13056434411','上海市卢湾区','1992-04-18 00:00:00',NULL,NULL)，('10008','123','何睛睛','女','1','13053445221','广州市天河区','1997-07-23 00:00:00',NULL,NULL)，('20000','123','王宝宝','男','2','15076552323','地址不详','1996-06-05 00:00:00',NULL,NULL)，('20010','123','何小华','女','2','13318877954','地址不详','1995-09-10 00:00:00',NULL,NULL)，('30011','123','陈志强','男','3','13689965430','地址不详','1994-09-27 00:00:00',NULL,NULL)，('30012','123','李露露','女','3','13685678854','地址不详','1992-09-27 00:00:00',NULL,NULL); /*result表数据*/[br][/br] insert into result (studentNo, subjectNo, examDate, studentResult) values('10000','1','2016-02-15 00:00:00','71')，('10000','1','2016-02-17 00:00:00','60')，('10001','1','2016-02-17 00:00:00','46')，('10002','1','2016-02-17 00:00:00','83')，('10003','1','2016-02-17 00:00:00','60')，('10004','1','2016-02-17 00:00:00','60')，('10005','1','2016-02-17 00:00:00','95')，('10006','1','2016-02-17 00:00:00','93')，('10007','1','2016-02-17 00:00:00','23');

举一反三

内容

0
在以下4个时间段内,不属于驾驶员疲劳驾驶应警惕的时间段是()。 A: 1:00~3:00 B: 11:00~13:00 C: 17:00~19:00 D: 21:00~23:00
1
北京时间10月20日22：00，此时西12区地方时为（）。 A: 10月20日18：00 B: 10月21日18：00 C: 10月21日02：00 D: 10月20日02：00
2
当归补血汤中黄芪与当归的用量比例为（） A: 06:01:00 B: 05:02:00 C: 07:01:00 D: 02:01:00 E: 05:01:00
3
循环式规约(CDT) EB 90 EB 90 EB 90 71 F4 02 01 00 9B F0 01 00 00 80 F6 F1 00 00 00 00 94,F6为
4
根据人体生理节律，人体在（）时机体反应迟钝。 A: 06:00～09:02 B: 10:00～11:02 C: 13:00～14:02