题解 | #插入记录（一）#
插入记录（一）
http://www.nowcoder.com/practice/5d2a42bfaa134479afb9fffd9eee970c
/*insert into exam_record(uid, exam_id, start_time, submit_time, score)
select 1001, 9001, '2021-09-01 22:11:12', '2021-09-01 23:01:12', 90
union all
select 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);
select 1001, 9001, '2021-09-01 22:11:12', '2021-09-01 23:01:12', 90
union all
select 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);
查看10道真题和解析