「牛客网-SQL篇」SQL115 删除记录（一）

「牛客网-SQL篇」SQL115 删除记录（一）

题目

SQL115 删除记录（一）

我的解答

delete from
    exam_record
where
    MINUTE(submit_time-start_time)<5 and score <60;

错误。。。

知识点补充:timestampdiff

时间差函数 timestampdiff

TIMESTAMPDIFF() :

This function in MySQL is used to return a value after subtracting a DateTime expression from another.

Syntax :

TIMESTAMPDIFF(unit,expr1,expr2)

Parameters :

It will accept three parameters.

• unit –