mysql示例数据库world安装
1、数据库脚本下载页面 http://dev.mysql.com/doc/index-other.html ,选择Example Databases
TitleDownload DBHTML Setup GuidePDF Setup Guide
employee data (large dataset, includes data and test/verification suite)LaunchpadViewUS Ltr | A4
world databaseGzip | ZipViewUS Ltr
world_x databaseTGZ | Zip
sakila databaseTGZ | ZipViewUS Ltr | A4
menagerie databaseTGZ | Zip
2、脚本上传到mysql服务器后解压
unzip world.sql.zip
产生文件world.sql
3、执行sql world.sql文件
mysql -uroot -pgbase123 -t <world.sql
4、验证数据库产生情况
mysql -uroot -pgbase123
show databases;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
| world |
+--------------------+
6 rows in set (0.00 sec)
显示存在 world
5、打开数据world查看表的创建情况
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)
mysql> select count(1) from countrylanguage;
+----------+
| count(1) |
+----------+
| 984 |
+----------+
1 row in set (0.00 sec)
world数据库示例成功创建。
格式还是有点问题
页:
[1]