MySQL示例数据库sakila-db的安装导入

83 阅读 0 评论 55 点赞

我是靠谱客的博主火星上棉花糖，最近开发中收集的这篇文章主要介绍MySQL示例数据库sakila-db的安装导入，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

 
  MySQL示例数据库sakila-db的安装导入 
 

下载： https://dev.mysql.com/doc/index-other.html 或 http://downloads.mysql.com/docs/sakila-db.zip

[root@LHRDB tmp]# unzip sakila-db.zip
Archive: sakila-db.zip
creating: sakila-db/
inflating: sakila-db/sakila-data.sql
inflating: sakila-db/sakila-schema.sql
inflating: sakila-db/sakila.mwb
[root@LHRDB tmp]# cd sakila-db
[root@LHRDB sakila-db]# ll
total 3396
-rw-r--r-- 1 root root 3398148 Jul 21 2016 sakila-data.sql
-rw-r--r-- 1 root root 50019 Jul 21 2016 sakila.mwb
-rw-r--r-- 1 root root 23424 Jul 21 2016 sakila-schema.sql
[root@LHRDB sakila-db]# mysql < sakila-schema.sql
[root@LHRDB sakila-db]# mysql < sakila-data.sql
[root@LHRDB sakila-db]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 5
Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_name |
| db_name2 |
| lhrdb |
| mysql |
| performance_schema |
| sakila |
| sys |
+--------------------+
8 rows in set (0.05 sec)

mysql> use sakila;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------------------+
| Tables_in_sakila |
+----------------------------+
| actor |
| actor_info |
| address |
| category |
| city |
| country |
| customer |
| customer_list |
| film |
| film_actor |
| film_category |
| film_list |
| film_text |
| inventory |
| language |
| nicer_but_slower_film_list |
| payment |
| rental |
| sales_by_film_category |
| sales_by_store |
| staff |
| staff_list |
| store |
+----------------------------+
23 rows in set (0.00 sec)

mysql> select count(*) from customer;
+----------+
| count(*) |
+----------+
| 599 |
+----------+
1 row in set (0.00 sec)

通常情况下对于一个全新的MySQL服务器，没有任何数据供我们测试和使用。对此，MySQL为我们提供了一些样本数据库，我们可以基于这些数据库作基本的操作以及压力测试等等。本文描述的是安装sakila数据库。该数据库需要安装在MySQL 5.0以上的版本。以下是其描述。