根据条件 start_time 和 submit_time
update exam_record set score = 0,submit_time = '2099-01-01 00:00:00' where start_time < '2021-09-01' and submit_time is NULL
update exam_record set score = 0,submit_time = '2099-01-01 00:00:00' where start_time < '2021-09-01' and submit_time is NULL
牛客博客，记录你的成长
京公网安备 11010502036488号