我不打朋友圈

分类

题解(359)

/ 注册

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

我居南半坡

203篇文章 2272人学习

西坡之上一枯木

1篇文章 655人学习

全部文章（共309篇）

题解 | #树的子结构#

/** public class TreeNode { int val = 0; TreeNode left = null; TreeNode right = null; public TreeNode(int val) { this.val = val; } } */ public c...

Java

2021-12-17

0 402

题解 | #重建二叉树#

// / import java.util.Arrays; public class Solution { public TreeNode reConstructBinaryTree(int [] pre,int [] vin) { if (pre.length == 0 || vin.length...

Java

2021-12-17

0 327

题解 | #二叉搜索树的第k个节点#

import java.util.*; /* public class TreeNode { int val = 0; TreeNode left = null; TreeNode right = null; public TreeNode(int val) { this.val = val; ...

Java

2021-12-17

0 344

题解 | #按之字形顺序打印二叉树#

import java.util.ArrayList; import java.util.Collections; /* public class TreeNode { int val = 0; TreeNode left = null; TreeNode right = null; public ...

Java

2021-12-17

0 339

题解 | #将所有获取奖金的员工当前的薪水增加10%#

update salaries set salary=salary*1.1 where emp_no in (select emp_no from emp_bonus) and to_date='9999-01-01' update salaries set salary = 1.1*salary ...

Mysql

2021-12-17

0 268

题解 | #在audit表上创建外键约束，其emp_no对应employees_test表的主键id#

ALTER TABLE audit ADD FOREIGN KEY (EMP_no) REFERENCES employees_test (ID); alter table audit add foreign key (emp_no) references employees_test (id)

Mysql

2021-12-17

0 253

题解 | #构造一个触发器audit_log#

create trigger audit_log after insert on employees_test for each row begin insert into audit values(new.id,new.name); end create trigger audit_log aft...

Mysql

2021-12-17

0 246

题解 | #针对上面的salaries表emp_no字段创建索引idx_emp_no#

select * from salaries force index (idx_emp_no) where emp_no=10005; select * from salaries force index(idx_emp_no) where emp_no = 10005

Mysql

2021-12-17

0 300

题解 | #针对actor表创建视图actor_name_view#

create view actor_name_view as select first_name as first_name_v,last_name as last_name_v from actor create view actor_name_view as select first_name ...

Mysql

2021-12-17

0 322

题解 | #创建一个actor表，包含如下列信息#

create table actor ( actor_id smallint(5) not null primary key comment '主键id', first_name varchar(45) not null comment '名字', last_name varchar(45) not...

Mysql

2021-12-17

0 276