delete from exam_record
where submit_time is null 
or timestampdiff(minute, start_time, submit_time) < 5
order by start_time
limit 3

在得到满足条件后,再去求得前三条就好,这里主要是记住是一个or的条件。

然后求时间的函数 timestampdiff(minute,start_time,submit_time) 可以求得两个timestamp的时间差。