数据库练习一：安装Employees 测试数据库

介绍

• Employees Sample Database 是官方自带的数据库。里面有几百万条数据。
• 所以我就借用该数据库进行SQL语句的练习以及对数据库的优化

表结构图

image.png image.png

安装数据库

1. git 下载地址。
2. 进入到项目
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

则导入成功，可以开始玩了。