nicer_but_slower_film_list
Documentation | Sakila |
Name | nicer_but_slower_film_list |
Module | Views |
The nicer_but_slower_film_list view contains a formatted view of the film table, with a comma-separated list of the film's actors.
The nicer_but_slower_film_list view differs from the film_list view in the list of actors. The lettercase of the actor names is adjusted so that the first letter of each name is capitalized, rather than having the name in all-caps.
As indicated in its name, the nicer_but_slower_film_list view performs additional processing and therefore takes longer to return data than the film_list view.
The nicer_but_slower_film_list view incorporates data from the film, category, film_category, actor, and film_actor tables.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | FID | unsigned smallint(5, 0) | Default: 0 | The film ID. | ||||
The film ID. Default: 0 |
||||||||
2 | title | varchar(255) | The title of the film. | |||||
The title of the film. |
||||||||
3 | description | text | A short description or plot summary of the film. | |||||
A short description or plot summary of the film. |
||||||||
4 | category | varchar(25) | The film category. | |||||
The film category. |
||||||||
5 | price | decimal(4, 2) | Default: 4.99 | The cost to rent the film. | ||||
The cost to rent the film. Default: 4.99 |
||||||||
6 | length | unsigned smallint(5, 0) | The duration of the film. | |||||
The duration of the film. |
||||||||
7 | rating | enum | Default: G | The rating assigned to the film. | ||||
The rating assigned to the film. Default: G |
||||||||
8 | actors | text | The actor's full names. | |||||
The actor's full names. |
Script
select `sakila`.`film`.`film_id` AS `FID`,`sakila`.`film`.`title` AS `title`,`sakila`.`film`.`description` AS `description`,`sakila`.`category`.`name` AS `category`,`sakila`.`film`.`rental_rate` AS `price`,`sakila`.`film`.`length` AS `length`,`sakila`.`film`.`rating` AS `rating`,group_concat(concat(concat(upper(substr(`sakila`.`actor`.`first_name`,1,1)),lower(substr(`sakila`.`actor`.`first_name`,2,length(`sakila`.`actor`.`first_name`))),' ',concat(upper(substr(`sakila`.`actor`.`last_name`,1,1)),lower(substr(`sakila`.`actor`.`last_name`,2,length(`sakila`.`actor`.`last_name`)))))) separator ', ') AS `actors` from ((((`sakila`.`category` left join `sakila`.`film_category` on((`sakila`.`category`.`category_id` = `sakila`.`film_category`.`category_id`))) left join `sakila`.`film` on((`sakila`.`film_category`.`film_id` = `sakila`.`film`.`film_id`))) join `sakila`.`film_actor` on((`sakila`.`film`.`film_id` = `sakila`.`film_actor`.`film_id`))) join `sakila`.`actor` on((`sakila`.`film_actor`.`actor_id` = `sakila`.`actor`.`actor_id`))) group by `sakila`.`film`.`film_id`,`sakila`.`category`.`name` |
Exported: 2018-10-12 17:43, Last imported: 2018-08-06 10:44