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;