由题意，新表结构和exam_record表一致，含有自增列， 故不能直接将整个exam_record表复制过去，需筛选能复制的列
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'
由题意，新表结构和exam_record表一致，含有自增列， 故不能直接将整个exam_record表复制过去，需筛选能复制的列
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'
牛客博客，记录你的成长
京公网安备 11010502036488号