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

INSERT INTO exam_record_before_2021
    SELECT
        null,uid,exam_id,start_time,submit_time,score
    FROM exam_record
    WHERE
    year(submit_time) < 2021

或者

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