mysql官方测试库

sql语句优化时没有测试数据，oracle官方提供测试数据

?

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

　到 https://github.com/datacharmer/test_db下载

安装

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

unzip test_db-master.zip mysql -u root -p  -t < employees.sql mysql -u root -p  -t < employees_partitioned.sql 测试安装的数据 mysql -u root -p  -t < test_employees_md5.sql mysql> show tables; +----------------------+ | Tables_in_employees  | +----------------------+ | current_dept_emp     | | departments          | | dept_emp             | | dept_emp_latest_date | | dept_manager         | | employees            | | salaries             | | titles               | +----------------------+ 8 rows in set (0.00 sec)