sakila 导入mysql_MySQL示例数据库sakila-db的安装导入-阿里云开发者社区

[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)