题解 | #插入记录（二）#
插入记录（二）
http://www.nowcoder.com/practice/9681abf28745468c8adacb3b029a18ce
由题意，新表结构和exam_record表一致，含有自增列， 故不能直接将整个exam_record表复制过去，需筛选能复制的列
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'
