oj-sql

题目

SQL114 更新记录（二）

思路

1. 简单更新语句；

solution

update where

update exam_record
set
    submit_time='2099-01-01 00:00:00',
    score=0
where start_time<'2021-09-01 00:00:00' and score is null;