Sakila Table Overview

Sakila Table Overview

I have created this blog to cover the tables used in the MySQL JOINS blog. This blog gives an idea about the structure of specific tables from the Sakila Database.


Category Table:

SELECT * FROM category;

Output:


Film Table:

SELECT * FROM film;

Output:

For a better understanding, here is the description of the table.

DESC film;

Output:


Customer Table:

SELECT * FROM customer;

Output:


Payment Table:

SELECT * FROM payment;

Output:


Inventory Table:

SELECT * FROM inventory;

Output:


Rental Table:

SELECT * FROM rental;

Output:


Actor Table:

SELECT * FROM actor;

Output:


*****All the outputs provided are a snippet of the actual result.