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.
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. :
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!