mysql timestampdiff 时间间隔

DELETE FROM 
# SECOND 秒
# MINUTE 分钟（返回秒数差除以60的整数部分）
# HOUR 小时（返回秒数差除以3600的整数部分）
# DAY 天数（返回秒数差除以3600*24的整数部分）
# MONTH 月数
# YEAR 年数
# year ,month ,day,hour,second, minute       ,start_time ,submit_time
exam_record WHERE score<60 and TIMESTAMPDIFF(minute,start_time,submit_time)<5

DELETE
FROM exam_record WHERE submit_time is null or TIMESTAMPDIFF(minute,start_time,submit_time)<5 ORDER BY start_time LIMIT 3