未完成即submit_time是空的,这个是关键 其次做字段的更新,使用update即可 注意同时更新两个字段,需要用逗号隔开 update exam_record set submit_time="2099-01-01 00:00:00", score = 0 where start_time<"2021-09-01 00:00:00" and submit_time is null