在导入employee-1.0.6 训练集的时候报错
INFO
CREATING DATABASE STRUCTURE
ERROR 1193 (HY000) at line 38: Unknown system variable ‘storage_engine’
employees.sql 第38行:
set storage_engine = InnoDB;
原因是MySQL5.7.5版本以后这个变量被移除了,改为default_storage_engine即可
同样地两个地方都需要修改
再次加载就可以了
mysql -uroot -p playground employees.sql
INFO
CREATING DATABASE STRUCTURE
INFO
storage engine: InnoDB
INFO
LOADING departments
INFO
LOADING employees
INFO
LOADING dept_emp
INFO
LOADING dept_manager
INFO
LOADING titles
INFO
LOADING salaries