题解 | #删除记录（二）#
删除记录（二）
https://www.nowcoder.com/practice/964c9f7fffbb4ab18b507cfed4111b4a
delete from exam_record
where submit_time is null
or TIMESTAMPDIFF(MINUTE,start_time,submit_time) < 5
ORDER BY start_time
Limit 3;
delete from删除代码
选择条件
TIMESTAMPDIFF(MINUTE,start_time,submit_time) 函数可以计算间隔 年月日分钟都可以
查看4道真题和解析