SQL2 插入记录(二)
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';
使用start_time来判断会出错,比如2020,2021才完成
普通插入(全字段)
INSERT INTO table_n
原创
2022-04-26 17:14:11 ·
184 阅读 ·
0 评论