film_list
| Documentation | Sakila |
| Name | film_list |
| Module | Views |
The film_list view contains a formatted view of the film table, with a comma-separated list of the film's actors.
The 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(`sakila`.`actor`.`first_name`,' ',`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