题解 | #删除记录(一)#
删除记录(一)
http://www.nowcoder.com/practice/d331359c5ca04a3b87f06b97da42159c
DELETE FROM exam_record WHERE TIMESTAMPDIFF(MINUTE, start_time, submit_time) < 5 AND score<60; 最主要的是 TIMESTAMPDIFF(MINUTE, start_time, submit_time)函数的使用
删除记录(一)
http://www.nowcoder.com/practice/d331359c5ca04a3b87f06b97da42159c
DELETE FROM exam_record WHERE TIMESTAMPDIFF(MINUTE, start_time, submit_time) < 5 AND score<60; 最主要的是 TIMESTAMPDIFF(MINUTE, start_time, submit_time)函数的使用
相关推荐