mysql导入github-employees测试数据

github地址：https://github.com/datacharmer/test_db

我的是windows，故需要手动修改一下下：
打开 employees.sql 最后是这样：

SELECT ‘LOADING departments’ as ‘INFO’;
source load_departments.dump ;
SELECT ‘LOADING employees’ as ‘INFO’;
source load_employees.dump ;
SELECT ‘LOADING dept_emp’ as ‘INFO’;
source load_dept_emp.dump ;
SELECT ‘LOADING dept_manager’ as ‘INFO’;
source load_dept_manager.dump ;
SELECT ‘LOADING titles’ as ‘INFO’;
source load_titles.dump ;
SELECT ‘LOADING salaries’ as ‘INFO’;
source load_salaries1.dump ;
source load_salaries2.dump ;
source load_salaries3.dump ;
source show_elapsed.sql ;

需要把 source 后面的更改为绝对路径（如下：注意反斜杠）

SELECT ‘LOADING departments’ as ‘INFO’;
source C:/Users/Pig/Downloads/test_db-master/load_departments.dump ;
SELECT ‘LOADING employees’ as ‘INFO’;
source C:/Users/Pig/Downloads/test_db-master/load_employees.dump ;
SELECT ‘LOADING dept_emp’ as ‘INFO’;
source C:/Users/Pig/Downloads/test_db-master/load_dept_emp.dump ;
SELECT ‘LOADING dept_manager’ as ‘INFO’;
source C:/Users/Pig/Downloads/test_db-master/load_dept_manager.dump ;
SELECT ‘LOADING titles’ as ‘INFO’;
source C:/Users/Pig/Downloads/test_db-master/load_titles.dump ;
SELECT ‘LOADING salaries’ as ‘INFO’;
source C:/Users/Pig/Downloads/test_db-master/load_salaries1.dump ;
source C:/Users/Pig/Downloads/test_db-master/load_salaries2.dump ;
source C:/Users/Pig/Downloads/test_db-master/load_salaries3.dump ;
source C:/Users/Pig/Downloads/test_db-master/show_elapsed.sql ;

然后用cmd（管理员身份）命令导入（我用Navicat 会报错，好像不支持 source）

cmd切换到mysql路径（我的：D:\Program Files\mysql-8.0.16-winx64\bin）
mysql -u root -p
输入密码
source C:/Users/Pig/Downloads/test_db-master/employees.sql ;
回车等待即可