最早三条:先用order by升序,再用limit限制选择3条 timestampdiff可以计算时间差,这里选择的是按分钟计算 delete from exam_record where timestampdiff(minute,start_time,submit_time)<5 or submit_time is null order by start_time limit 3