题解 | #更新记录(二)#
更新记录(二)
https://www.nowcoder.com/practice/0c2e81c6b62e4a0f848fa7693291defc
update exam_record
set submit_time='2099-01-01 00:00:00',score=0
where date(start_time) <'2021-09-01' and submit_time is null;
更新记录(二)
https://www.nowcoder.com/practice/0c2e81c6b62e4a0f848fa7693291defc
update exam_record
set submit_time='2099-01-01 00:00:00',score=0
where date(start_time) <'2021-09-01' and submit_time is null;
相关推荐