跪求要一个offer

分类

题解(178)

/ 注册

TA的专栏 12篇文章 0人订阅

算法和编程题解

12篇文章 270人学习

全部文章（共183篇）

题解 | #统计每个月兔子的总数#

#include<stdio.h> int shu[37]; int main(){ int n; while(scanf("%d",&n)!=EOF){ shu[1]=1; shu[2]=1; int i; ...

C++

2022-01-29

0 0

题解 | #对过长的昵称截取处理#

#sql中char_length、concat和if函数的用法 select uid, if(char_length(nick_name)>13, concat(substr(nick_name,1,10),"..."), nick_name) as nick_...

Mysql

2022-01-26

1 0

题解 | #找出每个学校GPA最低的同学#

#查出每个学校最小的gpa select device_id, university, gpa from user_profile u where gpa=( select min(gpa) from user_profile where uni...

Mysql

2022-01-22

0 0

题解 | #二叉树的下一个结点#

/* struct TreeLinkNode { int val; struct TreeLinkNode *left; struct TreeLinkNode *right; struct TreeLinkNode *next; TreeLinkNode(i...

C++

2022-01-21

0 0

题解 | #对称的二叉树#

/* struct TreeNode { int val; struct TreeNode *left; struct TreeNode *right; TreeNode(int x) : val(x), left(NULL), right(N...

C++

2022-01-19

0 0

题解 | #修复串列了的记录#

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 430

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

#sql中replace的用法:如果已经存在该数据，则删除原有的数据并插入新数据 replace into examination_info values(null,9003,'SQL','hard',90,'2021-01-01 00:00:00');

Mysql

2022-01-17

0 383

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

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 553

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

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 283

题解 | #创建索引#

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 357