MySQL Sakila示例数据库

Table of Contents     

1 Preface and Legal Notices 2 Introduction 3 History 4 Installation 5 Structure      6 Usage Examples 7 Acknowledgments 8 License for the Sakila Sample Database 9 Note for Authors 10 Sakila Change History      在 https://dev.mysql.com/doc/index-other.html页面下载sakila-db.tar.gz

上传至服务器，解压

# 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.1.1 The actor Table 5.1.2 The address Table 5.1.3 The category Table 5.1.4 The city Table 5.1.5 The country Table 5.1.6 The customer Table 5.1.7 The film Table 5.1.8 The film_actor Table 5.1.9 The film_category Table 5.1.10 The film_text Table 5.1.11 The inventory Table 5.1.12 The language Table 5.1.13 The payment Table 5.1.14 The rental Table 5.1.15 The staff Table 5.1.16 The store Table

 

5.2 Views

5.2.1 The actor_info View 5.2.2 The customer_list View 5.2.3 The film_list View 5.2.4 The nicer_but_slower_film_list View 5.2.5 The sales_by_film_category View 5.2.6 The sales_by_store View 5.2.7 The staff_list View

 

5.3 Stored Procedures

5.3.1 The film_in_stock Stored Procedure 5.3.2 The film_not_in_stock Stored Procedure 5.3.3 The rewards_report Stored Procedure

 

5.4 Stored Functions

5.4.1 The get_customer_balance Function 5.4.2 The inventory_held_by_customer Function 5.4.3 The inventory_in_stock Function

 

5.5 Triggers

5.5.1 The customer_create_date Trigger 5.5.2 The payment_date Trigger 5.5.3 The rental_date Trigger 5.5.4 The ins_film Trigger 5.5.5 The upd_film Trigger 5.5.6 The del_film Trigger

 

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