这里就是进行表的数据的复制 insert into table_name (column1,column2,......) select (column1,column2,.....) from table_name2 where (key=value) 这里是根据题意来进行变化的 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_score where year(submit_time)<'2021' and 'submit_time' is not null;