和Oracle 数据库一样，mysql 也有自己的示例库，只不过Mysql的示例库和是文档放在一起的，需要单独的进行安装。http://www.cndba.cn/dave/article/2647http://www.cndba.cn/dave/article/2647http://www.cndba.cn/dave/article/2647http://www.cndba.cn/dave/article/2647

示例下载地址；
http://dev.mysql.com/doc/index-other.html

上面有5种类型的示例数据库。 选择需要的进行下载。

mysql> use cndba
Database changed
mysql> source /root/world.sql
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
….


mysql> show tables;
+-----------------+
| Tables_in_world |
+-----------------+
| city            |
| country         |
| countrylanguage |
+-----------------+
3 rows in set (0.00 sec)

mysql> select count(1) from city;
+----------+
| count(1) |
+----------+
|     4079 |
+----------+
1 row in set (0.00 sec)

mysql> select count(1) from country;
+----------+
| count(1) |
+----------+
|      239 |
+----------+
1 row in set (0.00 sec)

版权声明：本文为博主原创文章，未经博主允许不得转载。