Sakila サンプルデータベースをロードする

curl -O https://downloads.mysql.com/docs/sakila-db.zip
unzip sakila-db.zip

mysql -u root -p < sakila-db/sakila-schema.sql
mysql -u root -p < sakila-db/sakila-data.sql

mysql -u root -p -e "USE sakila; SHOW TABLES;"

Enter password:
+----------------------------+
| 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                      |
+----------------------------+

mysql -u root -p -e "SELECT COUNT(*) FROM sakila.film;"

Enter password:
+----------+
| COUNT(*) |
+----------+
|     1000 |
+----------+

mysql -u root -p sakila

USE sakila;

mysql -u root -p -e "SELECT COUNT(*) FROM film;"

Enter password:
ERROR 1046 (3D000) at line 1: No database selected