题解 | #插入记录（一）#

# 方法一：指定列名
# insert into exam_record (uid, exam_id, start_time, submit_time, score)
# values
# (1001, 9001, '2021-09-01 22:11:12', '2021-09-01 22:11:12' + interval 50 minute, 90),
# (1002, 9002, '2021-09-04 07:01:02', null, null)

# 方法二：不指定列名，但需要指定自增主键使用default值
insert into exam_record
values
(default, 1001, 9001, '2021-09-01 22:11:12', '2021-09-01 22:11:12' + interval 50 minute, 90),
(default, 1002, 9002, '2021-09-04 07:01:02', null, null)