mysql sakila_MySQL Sakila示例数据库

Table of Contents

上传至服务器，解压

# tar -xvf sakila-db.tar.gz

sakila-db/

sakila-db/sakila-data.sql

sakila-db/sakila-schema.sql

sakila-db/sakila.mwb

The sakila-schema.sql file contains all the CREATE statements required to create the structure of the Sakila database including tables, views, stored procedures, and triggers.

The sakila-data.sql file contains the INSERT statements required to populate the structure created by the sakila-schema.sql file, along with definitions for triggers that must be created after the initial data load.

The sakila.mwb file is a MySQL Workbench data model that you can open within MySQL Workbench to examine the database structure. For more information, see MySQL Workbench.

(dba_user@localhost) [(none)]> source /soft/sakila-db/sakila-schema.sql

(dba_user@localhost) [sakila]> source /soft/sakila-db/sakila-data.sql

5.1 Tables

5.2 Views

5.3 Stored Procedures

5.4 Stored Functions

5.5 Triggers

https://dev.mysql.com/doc/sakila/en/