OkMaid

分类

题解(34)

/ 注册

全部文章（共70篇）

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

DELETE FROM nowcoder_exam_record; ALTER TABLE nowcoder_exam_record auto_increment=1; truncate nowcoder_exam_record;

Mysql

2022-06-06

0 356

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

delete from exam_record where score is null or timestampdiff(minute, start_time, ...

Mysql

2022-06-04

0 318

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

delete from exam_record where score < 60 and timestampdiff(minute, start_time, ...

Mysql

2022-06-04

0 263

题解 | #更新记录（二）#

update exam_record set submit_time = '2099-01-01 00:00:00', score = 0 where start_time < '2021-09-01' and score is null

Mysql

2022-06-04

0 274

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

```REPLACE INTO examination_info VALUES(NULL,9003,'SQL','hard',90,'2021-01-01 00:00:00');

Mysql

2022-05-31

0 279

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

``insert into exam_record_before_2021 (uid, exam_id, start_time, submit_ti...

Mysql

2022-05-31

0 293

题解 | #将两个 SELECT 语句结合起来（二）#

```select prod_id, quantity from OrderItems where quantity = 100 or prod_id Like 'BNBG%'

Mysql

2022-05-30

0 450

题解 | #将两个 SELECT 语句结合起来（一）#

```select prod_id,quantity from OrderItems where quantity=100 union select prod_id,quantity from OrderItems where prod_id like 'BNBG%' order by prod_...

Mysql

2022-05-30

0 300

题解 | #列出供应商及其可供产品的数量#

```select v.vend_id, count(prod_id) from Products p right join Vendors v on p.vend_id = v.vend_id group by vend_id order by vend_id v.vend_id代表所有供应...

Mysql

2022-05-30

0 308

题解 | #返回产品名称和每一项产品的总订单数#

``select prod_name, count(order_num) as orders from Products p left join OrderItems oi on p.prod_id = oi.prod_id group b...

Mysql

2022-05-30

0 261