Date和String在比较的时候，会把String转化为Date
UPDATE exam_record
set submit_time='2099-01-01 00:00:00',score=0
WHERE start_time<'2021-09-01' and submit_time is null
Date和String在比较的时候，会把String转化为Date
UPDATE exam_record
set submit_time='2099-01-01 00:00:00',score=0
WHERE start_time<'2021-09-01' and submit_time is null
牛客博客，记录你的成长
京公网安备 11010502036488号