题解 | #更新记录(二)#
更新记录(二)
http://www.nowcoder.com/practice/0c2e81c6b62e4a0f848fa7693291defc
UPDATE exam_record
SET submit_time= '2099-01-01 00:00:00',score = 0
WHERE DATEDIFF(start_time,'2021-09-01 00:00:00') < 0
AND submit_time is NULL;
更新记录(二)
http://www.nowcoder.com/practice/0c2e81c6b62e4a0f848fa7693291defc
UPDATE exam_record
SET submit_time= '2099-01-01 00:00:00',score = 0
WHERE DATEDIFF(start_time,'2021-09-01 00:00:00') < 0
AND submit_time is NULL;
相关推荐