题解 | #Where in 和Not in#
插入记录(一)
http://www.nowcoder.com/practice/5d2a42bfaa134479afb9fffd9eee970c
insert into exam_record (id,uid,exam_id,start_time,submit_time,score) values (null,1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90), (null,1002,9002,'2021-09-04 07:01:02',null,null)
insert into exam_record(uid,exam_id,start_time,submit_time,score)
VALUES (1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12' ,90),
(1002,9002,'2021-09-04 07:01:02',null,NULL);
insert into exam_record (id,uid,exam_id,start_time,submit_time,score)
VALUES(null,1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90),
(null,1002,9002,'2021-09-04 7:01:02',null,null)
我居南半坡 文章被收录于专栏
多刷题,积蓄力量,欢迎讨论

