- 新表有自己的AI序号,不用原表id列
- 掌握 insert into 新表名 select * from 旧表名 where 1 的用法
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
SELECT null,uid,exam_id,start_time,submit_time,score FROM exam_record WHERE year(submit_time) <2021