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.3 Stored Procedures
5.4 Stored Functions
5.5 Triggers
https://dev.mysql.com/doc/sakila/en/
最新文章
- (转)C# XMPP客户端与openfire通信（Matrix Xmpp 授权破解教程）
- 【转】php中XML、XSLT的结合运用
- App开发流程之右滑返回手势功能续
- BizTalk开发系列(二十二) 开发自定义Map Functoid
- 编程中i++与++i的区别
- bzoj 2440: [中山市选2011]完全平方数
- Android Handler之Message传递参数
- librtmp推流使用aac编码音频的html5和flash播放问题
- 【二进制】FZU 2062 Suneast & Yayamao
- Apache Ant在Windows下配置环境变量
- if简单的写法之范围
- Parallel Python——一个简单的分布式计算系统
- java_log4j 经典配置
- 【开源.NET】轻量级内容管理框架Grissom.CMS（第三篇解析配置文件和数据以转换成 sql）
- JXLS 2.4.0系列教程（二）——循环导出一个链表的数据
- linux基本格式和常用目录命令一
- sass和scss的区别
- mySQL InnoDB 的性能问题讨论
- linux的系统调优
- Python3.5+SQL+Prometheus+Grafana报表/监控