MySql安装自带的测试数据库Employees

最新推荐文章于 2025-05-04 14:17:37 发布

小肖学数据分析

最新推荐文章于 2025-05-04 14:17:37 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： Mysql

本文链接：https://blog.youkuaiyun.com/qq_41387939/article/details/103675099

Mysql 专栏收录该内容

7 篇文章

订阅专栏

今天群里有个朋友想要弄点测试数据集，自己平时做做练习。接下来咱们搞起来。

MySQL有自带的数据库employees，容易安装，方面我们平时做测试或者自学使用。

MySql安装自带的测试数据库Employees

Windows安装版本

Linux安装版本

Windows安装版本

下载地址：https://launchpad.net/test-db/+download

官网https://dev.mysql.com/doc/employee/en/employees-installation.html

1）先解压缩文件，可以右键解压缩，也可以命令解压缩，我是用电脑右键WinRAR；

2）官网是要设置The Employees database is compatible with several different storage engines, with the InnoDB engine enabled by default. Edit the employee.sql file and adjust the comments to choose a different storage engine:

但是我发现我的employees.sql文件跟官网一样的如下

set storage_engine = InnoDB;

– set storage_engine = MyISAM;

– set storage_engine = Falcon;

– set storage_engine = PBXT;

– set storage_engine = Maria;

但是还会报错ERROR 1193 (HY000) at line 38: Unknown system variable ‘storage_engine’

查找原因是默认就是InnoDB,所以索性注释掉38-44行

– set storage_engine = InnoDB;

– set storage_engine = MyISAM;

– set storage_engine = Falcon;

– set storage_engine = PBXT;

– set storage_engine = Maria;

– select CONCAT(‘storage engine: ‘, @@storage_engine) as INFO;

3）导入我的这个测试数据放在了F:\DB\employees_db-full-1.0.6\employees_db目录下，那么就要在此目录下进行命令行操作
进入命令窗口

Linux安装版本

1.测试库下载：https://github.com/datacharmer/test_db

2.解压test_db-master.zip

3.输入该命令，导入employees.sql文件

mysql -u root -p < employees.sql

4.验证是否成功

mysql -u root -p < test_employees_md5.sql

INFO
TESTING INSTALLATION
table_name  expected_records    expected_crc
employees   300024  4ec56ab5ba37218d187cf6ab09ce1aa1
departments 9   d1af5e170d2d1591d776d5638d71fc5f
dept_manager    24  8720e2f0853ac9096b689c14664f847e
dept_emp    331603  ccf6fe516f990bdaa49713fc478701b7
titles  443308  bfa016c472df68e70a03facafa1bc0a8
salaries    2844047 fd220654e95aea1b169624ffe3fca934
table_name  found_records       found_crc
employees   300024  4ec56ab5ba37218d187cf6ab09ce1aa1
departments 9   d1af5e170d2d1591d776d5638d71fc5f
dept_manager    24  8720e2f0853ac9096b689c14664f847e
dept_emp    331603  ccf6fe516f990bdaa49713fc478701b7
titles  443308  bfa016c472df68e70a03facafa1bc0a8
salaries    2844047 fd220654e95aea1b169624ffe3fca934
table_name  records_match   crc_match
employees   OK  ok
departments OK  ok
dept_manager    OK  ok
dept_emp    OK  ok
titles  OK  ok
salaries    OK  ok
computation_time
00:00:13
summary result
CRC OK
count   OK

则导入成功。

若将数据导入mysql 5.7.17的时候报错如下：

ERROR 1193 (HY000) at line 38: Unknown system variable 'storage_engine'

修复以下内容就行了：
由原来的“storage_engine”改成“default_storage_engine”，如下：

下载测试库

安装导入数据

保存，再执行导入就正常了：

关注Excel螺丝钉，回复Mysql测试库，获取安装包