题解 | #删除记录(一)#
删除记录(一)
http://www.nowcoder.com/practice/d331359c5ca04a3b87f06b97da42159c
了解timediff, datediff 和timestampdiff时间函数的使用
方法一:使用 timestampdiff时间函数
delete from exam_record
where timestampdiff(minute, submit_time, start_time)<5
and score < 60;
方法二:使用timediff时间函数
DELETE FROM exam_record
where timediff(submit_time,start_time)<="00:05:00"
and score<60
查看1道真题和解析
小天才公司福利 1317人发布