跪求要一个offer
跪求要一个offer
全部文章
分类
题解(178)
归档
标签
去牛客网
登录
/
注册
跪求要一个offer的博客
TA的专栏
12篇文章
0人订阅
算法和编程题解
12篇文章
177人学习
全部文章
(共168篇)
题解 | #修复串列了的记录#
SELECT exam_id, SUBSTRING_INDEX(SUBSTRING_INDEX(tag,',',1),',',-1) as tag, SUBSTRING_INDEX(SUBSTRING_INDEX(tag,',',2),',',-1) as difficulty, SUBSTR...
Mysql
2022-01-17
0
316
题解 | #插入记录(三)#
#sql中replace的用法:如果已经存在该数据,则删除原有的数据并插入新数据 replace into examination_info values(null,9003,'SQL','hard',90,'2021-01-01 00:00:00');
Mysql
2022-01-17
0
239
题解 | #插入记录(二)#
insert into exam_record_before_2021 (uid,exam_id,start_time,submit_time,score) select uid,exam_id,start_time,submit_time,score from exam_record where...
Mysql
2022-01-16
1
442
题解 | #插入记录(一)#
insert into exam_record (uid,exam_id,start_time,submit_time,score) values (1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90), (1002,9002,'...
Mysql
2022-01-16
0
196
题解 | #创建索引#
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-14
0
272
题解 | #统计作答次数#
来自专栏
select count(start_time) as total_pv, COUNT(submit_time) as complete_pv, #去除未完成的试卷 COUNT(distinct exam_id and score is not null) as comple...
Mysql
2022-01-14
0
177
题解 | #删除索引#
#sql中删除索引的语法 drop index uniq_idx_exam_id on examination_info; drop index full_idx_tag on examination_info;
Mysql
2022-01-14
0
223
题解 | #修改表#
#sql修改 表结构的语法 alter table user_info add school varchar(15) after level; alter table user_info change job profession varchar(10); alter table user...
Mysql
2022-01-13
0
149
题解 | #查看不同年龄段的用户明细#
#sql中case when end的用法 select device_id,gender, case when age>=25 then '25岁及以上' when age>=20 then '20-24岁' else '其他' ...
Mysql
2022-01-12
0
177
题解 | #跳台阶扩展问题#
public: int jumpFloorII(int number) { //使用递归的暴力解法 int shu[20]={0}; shu[0]=1; shu[1]=1; shu[2]=2; i...
C++
2022-01-11
0
164
首页
上一页
1
2
3
4
5
6
7
8
9
10
下一页
末页