题解 | #删除记录(一)#
删除记录(一)
http://www.nowcoder.com/practice/d331359c5ca04a3b87f06b97da42159c
计算时间差 timestampdiff(minute,time1,time2)
delete FROM exam_record
where score <60 and timestampdiff(minute,start_time,submit_time)<5
删除记录(一)
http://www.nowcoder.com/practice/d331359c5ca04a3b87f06b97da42159c
计算时间差 timestampdiff(minute,time1,time2)
delete FROM exam_record
where score <60 and timestampdiff(minute,start_time,submit_time)<5
相关推荐