牛客220053790号

题解

/ 注册

全部文章 / 题解（共2篇）

题解 | #删除记录（二）#

delete from exam_record WHERE submit_time is NULL or TIMESTAMPDIFF(minute, start_time, submit_time) < 5 order by start_time limit 3;

Mysql

2021-10-20

12 2727

题解 | #插入记录（一）#

INSERT INTO exam_record VALUES (NULL,1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90), (NULL,1002,9002,'2021-09-04 07:01:02',NULL,NULL);

Mysql

2021-10-20

1 771