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

interval 时间间隔关键字，常和date_add() 或 date_sub()搭配使用。

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);

or

insert into exam_record (uid, exam_id, start_time, submit_time, score) 
values
(1001, 9001, "2021-09-01 22:11:12", DATE_ADD("2021-09-01 22:11:12", INTERVAL 50 minute), 90),
(1002, 9002, "2021-09-04 07:01:02",NULL,NULL);