Home  >  Article  >  Database  >  what is mysql sakila

what is mysql sakila

藏色散人
藏色散人Original
2023-04-05 10:59:503240browse

mysql sakila is a sample database; the sakila sample database is a database officially provided by MySQL to simulate DVD rental information management. It provides a standard model that can be used as examples, tutorials, articles, samples, etc. in books.

what is mysql sakila

The operating environment of this tutorial: Windows 10 system, mysql8 version, Dell G3 computer.

What is mysql sakila?

MySQL Sakila sample database

Sakila sample database introduction

The Sakila sample database is a database officially provided by MySQL to simulate DVD rental information management. It provides a standard model that can be used as examples in books, tutorials, articles, samples, etc. It is a good choice for learning and testing. s Choice.

1. Download address:

MySQL :: Other MySQL Documentation https://dev.mysql.com/doc/index-other .html

(Example Databases --> sakila database --> zip package or .tar.gz package is acceptable)

2. After decompressing the imported data Get 3 files:

sakila.mwb workbench data model

sakila-data.sql table record information

sakila-schema.sql table structure Information

Import two SQL files (import the table structure first, then fill in the data; under Linux # source xx.sql under Windows SQLyog Ctrl shift Q can be executed)

3. Interpretation of the DVD rental business process of the sakila sample database

The sakila database mainly describes the business process of the DVD rental system. Here are the key points to explain how the process operates. :

  • Each store maintains its own list of rental movies. When a customer picks up or returns a DVD disc, a dedicated store clerk will maintain the list;
  • The content described in the film is also within the scope of maintenance information, such as category (action, adventure, comedy, etc.), actors, ratings, special categories (such as deleted plots and trailers). This information may be printed on the label of the DVD package;
  • You must register as a member in the store before you can rent the disc;
  • Customers can Any store rents one or more optical discs, and the store hopes to plan previously rented discs within the rental period corresponding to each disc;
  • Customers can purchase any rented disc at any time CD payment;

4. Data library model relationship

##For a more detailed description of the Sakila sample database, please refer to the official documentation: https://dev.mysql.com/doc/sakila/en/

Recommended learning: "

MySQL Video Tutorial

The above is the detailed content of what is mysql sakila. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn