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

insert into exam_record_before_2021
	(uid,exam_id,start_time,submit_time,score)
select uid,exam_id,start_time,submit_time,score
from exam_record
where
	year(submit_time)<"2021" 
and 
	submit_time is not null;