All sample databasesSakila
Video rental · sakila.demodb.dev
Sakila
sample database.
MySQL's sample video rental database, with films, actors, customers, rentals, payments, and stores.
-- Films by category
SELECT film_list.title, film_list.category, film_list.price FROM
16 tables · 7 views · 47,268 rows
-- 7 high-confidence cross-database table matches
16tables
7views
47,268table rows
Schema at a glance
Browse the recordsets.
table actor Performers available to be associated with films. 4 columns · 0 links · 200 rows table address Customer, staff, and store addresses, including the source's location geometry as a binary value. 9 columns · 1 links · 603 rows table category Film categories used to classify the catalogue. 3 columns · 0 links · 16 rows · 1 matches in other samples table city Cities associated with addresses and countries. 4 columns · 1 links · 600 rows table country Countries associated with cities. 3 columns · 0 links · 109 rows table customer People registered to rent films from a store. 9 columns · 2 links · 599 rows · 2 matches in other samples table film The film catalogue, including language, rating, rental terms, and special features. 13 columns · 2 links · 1,000 rows table film_actor The many-to-many association between films and actors. 3 columns · 2 links · 5,462 rows table film_category The many-to-many association between films and categories. 3 columns · 2 links · 1,000 rows
Downloads
Use this fixture
where you work.
Available files are generated from the provider’s pinned database contract. Pick a complete database or a single table.