oj-sql

题目

SQL111 插入记录（二）

思路

1. 简单插入语句；
2. 判断年，可以直接对比，也可以使用year函数提取年；

solution

insert into

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 submit_time < '2021-01-01 00:00:00';

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;