spln
spln
全部文章
分类
题解(18)
归档
标签
去牛客网
登录
/
注册
spln的博客
全部文章
(共17篇)
题解 | #针对actor表创建视图actor_name_view#
create view actor_name_view (first_name_v, last_name_v) as select first_name, last_name from actor;
Mysql
2022-01-11
0
218
题解 | #更新记录(二)#
update exam_record set submit_time = '2099-01-01 00:00:00', score = 0 where start_time < '2021-09-01' and submit_time is null;
Mysql
2022-01-11
1
329
题解 | #插入记录(三)#
delete from examination_info where exam_id = 9003; insert into examination_info (exam_id, tag, difficulty, duration, release_time) values (9003, 'SQL'...
Mysql
2022-01-10
0
212
题解 | #插入记录(二)#
insert into exam_record_before_2021 select null, uid, exam_id, start_time, submit_time, score from exam_record where submit_time < '202...
Mysql
2022-01-10
0
196
题解 | #插入记录(一)#
insert into exam_record (uid, exam_id, start_time, submit_time, score) values (1001, 9001,'2021-9-1 22:11:12', '2021-9-1 23:01:12', 90); insert into e...
Mysql
2022-01-10
0
178
题解 | #删除索引#
drop index uniq_idx_exam_id on examination_info; drop index full_idx_tag on examination_info;
Mysql
2022-01-09
0
217
题解 | #创建索引#
create index idx_duration on examination_info(duration); create unique index uniq_idx_exam_id on examination_info(exam_id); create fulltext index full...
Mysql
2022-01-09
0
198
题解 | #删除表#
drop table if exists exam_record_2011, exam_record_2012, exam_record_2013, exam_record_2014;
Mysql
2022-01-09
1
470
题解 | #修改表#
alter table user_info add school varchar(15) after level; alter table user_info change job profession varchar(10); alter table user_info modify achiev...
Mysql
2022-01-09
0
248
题解 | #建立一张新表#
建立表 create table user_info_vip ( id int(11) not null primary key auto_increment comment'自增ID', uid int(11) not null unique comment'用户ID', ...
Mysql
2022-01-09
5
628
首页
上一页
1
2
下一页
末页