题解 | #更新记录(二)#
更新记录(二)
https://www.nowcoder.com/practice/0c2e81c6b62e4a0f848fa7693291defc
update exam_record set submit_time = "2099-01-01 00:00:00", score = 0 where start_time < '2021-9-1' and submit_time is NULL
set后有多个条件,用,逗号分隔
判断为空用is null
更新记录(二)
https://www.nowcoder.com/practice/0c2e81c6b62e4a0f848fa7693291defc
update exam_record set submit_time = "2099-01-01 00:00:00", score = 0 where start_time < '2021-9-1' and submit_time is NULL
set后有多个条件,用,逗号分隔
判断为空用is null
相关推荐
查看10道真题和解析