题解 | #删除记录(一)#
删除记录(一)
https://www.nowcoder.com/practice/d331359c5ca04a3b87f06b97da42159c
本题主要考验sql语法中的timestampdiff函数 可以选择second或者minute为单位,具体代码如下
delete from exam_record where timestampdiff (second, start_time, submit_time) <= 300 and score < 6
删除记录(一)
https://www.nowcoder.com/practice/d331359c5ca04a3b87f06b97da42159c
本题主要考验sql语法中的timestampdiff函数 可以选择second或者minute为单位,具体代码如下
delete from exam_record where timestampdiff (second, start_time, submit_time) <= 300 and score < 6
相关推荐