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

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

新表的id是自增的，不能使用select *