ERROR 1193 (HY000) at line 38: Unknown system variable ‘storage_engine‘解决

在导入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