不穿胖次的羊

分类

/ 注册

全部文章（共33篇）

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

create trigger audit_log after insert on employees_test for each row begin insert into audit values(new.id,new.name); end 触发后执行操作的语句不要忘记‘；’，不然会报错

2024-01-20

0 75

题解 | #创建一个actor_name表#

create table if not exists actor_name( first_name varchar(45) not null, last_name varchar(45) not null ); insert into actor_name select first...

2024-01-18

0 78

题解 | #批量插入数据#

insert into actor (actor_id,first_name,last_name,last_update) values( '1','PENELOPE','GUINESS','2006-02-15 12:34:33' ),('2','NICK','WAHLBERG','200...

2024-01-18

0 58

题解 | #小数化整数#

import sys print(int(float(input())))

2024-01-17

0 70

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

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

2024-01-17

0 85

题解 | #将employees表的所有员工的last_n#

select concat(last_name,' ',first_name) Name from employees

2024-01-17

0 70

题解 | #使用子查询的方式找出属于Action分类的所有#

select title,description from film where film_id in ( select film_id from category a left join film_category b on a.category_id = b.category_id wher...

2024-01-17

0 80

题解 | #使用join查询方式找出没有分类的电影id

select f.film_id,f.title from film f left join film_category c on c.film_id = f.film_id where category_id is null 不清楚给类别表有什么用

2024-01-17

0 83

题解 | #汇总各个部门当前员工的title类型的分配数目#

select a.dept_no,b.dept_name,c.title,count(1) count from dept_emp a left join departments b on a.dept_no = b.dept_no left join titles c on c.emp_no...

2024-01-16

0 90

题解 | #获取员工其当前的薪水比其manager#

select a.emp_no,b.emp_no,c.salary,d.salary from dept_emp a left join dept_manager b on a.dept_no = b.dept_no left join salaries c on a.emp_no = c...

2024-01-16

0 97