练习mysql的语法,同样可以使用employees数据库,https://launchpad.net/test-db/employees-db-1/1.0.6 ,下载后导入数据库,但在执行如下命令时分别碰到如下错误,该如何处理呢?
问题1:
myhost:/home/employees/employees_db # mysql -t -uroot -pxxxxxxx < employees.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
+-----------------------------+
| INFO |
+-----------------------------+
| CREATING DATABASE STRUCTURE |
+-----------------------------+
ERROR 1193 (HY000) at line 38: Unknown system variable 'storage_engine'
解决方法:由于mysql5.7.5以后,storage_engine这个变量被移除了,employees.sql 改用default_storage_engine就可以了,清理包括如下两个地方,大家晚一点。
myhost:/home/employees/employees_db # vi employees.sql
set def