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.