OkMaid

分类

题解(34)

/ 注册

全部文章（共68篇）

题解 | #修改表#

alter table user_info add column school varchar(15) after level; alter table user_info change job profession varchar(10); alter table user_info modify...

Mysql

2022-06-08

0 285

题解 | #创建一张新表#

create table user_info_vip( id int(11) not null primary key auto_increment comment '自增ID', uid int(11) not null unique key comment '用户ID', nick_name v...

Mysql

2022-06-08

0 244

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

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