# 更新表的基本语法：update 表名 set 列名=值 where 筛选条件
update exam_record
set submit_time='2099-01-01 00:00:00', score=0
where submit_time is null and datediff('2021-09-01 00:00:00', start_time)>0;