牛客593719959号

题解

/ 注册

全部文章 / 题解（共56篇）

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

sql script alter table actor add create_date datetime not null default '2020-10-01 00:00:00'

sql

2021-09-06

0 325

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

sql script create view actor_name_view as select first_name as first_name_v, last_name as last_name_v from actor;

sql

2021-09-06

0 349

题解 | #对first_name创建唯一索引uniq_idx_firstname#

sql script alter table actor add unique uniq_idx_firstname (first_name); alter table actor add index idx_lastname (last_name);

sql

2021-09-06

0 294

题解 | #创建一个actor_name表#

sql script create table actor_name ( first_name varchar(45) not null comment '名字', last_name varchar(45) not null comment '姓氏' ); insert int...

sql

2021-09-06

0 253

题解 | #批量插入数据，不使用replace操作#

sql script insert ignore into actor (actor_id, first_name, last_name, last_update) values (3, 'ED', 'CHASE', '2006-02-15 12:34:33')

sql

2021-09-05

0 322

题解 | #批量插入数据#

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

sql

2021-09-05

0 298

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

sql script create table `actor` ( actor_id smallint(5) not null comment '主键id', first_name varchar(45) not null comment '名字', last_name v...

sql

2021-09-05

0 390

题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#

sql script select f.title, f.description from film f, category c, film_category fc where f.film_id=fc.film_id and c.category_id=fc.category_id and c....

sql

2021-09-05

0 255

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

sql script select f.film_id, f.title from film f left join film_category fc on f.film_id=fc.film_id where fc.category_id is NULL

sql

2021-09-05

0 243

题解 | #查找描述信息中包含robot的电影对应的分类名称以及电影数目，而且还需要该分类对应电影数量>=5部#

sql script select tmp.name,tmp.count_film_id from film f, category c, film_category fc, (select c.name as name, count(f.film_id) as count_film_id ...

sql

2021-09-01

0 302