掌握 timestampdiff(interval,datetime1,datetime2),返回结果是datetime2-datetime1,结果类型是int(推测,不确定)。
DELETE FROM exam_record
WHERE score<60 and TIMESTAMPDIFF(minute,start_time,submit_time)<5
掌握 timestampdiff(interval,datetime1,datetime2),返回结果是datetime2-datetime1,结果类型是int(推测,不确定)。
DELETE FROM exam_record
WHERE score<60 and TIMESTAMPDIFF(minute,start_time,submit_time)<5