复制的几种方式

新表结构要与旧表结构一样

  • insert into 新表 select * from 旧表
  • insert into 新表（列名，列名...）select 列名，列名... from 旧表
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'