The used command is not allowed with this MySQL version

janneyabc

The used command is not allowed with this MySQL version　　导入数据的时候，报如上错误！发现从本地导入文件的参数没有打开
mysql> SHOW VARIABLES LIKE '%local%';　　
+---------------+-------+
　　
| Variable_name | Value |
　　
+---------------+-------+
　　
| local_infile  | OFF   |
　　
+---------------+-------+
　　
1 row in set (0.00 sec)
　　开启该参数，因为是全局参数，所以需要加上global
SET GLOBAL local_infile=1　　再次导入数据，导入成功！
LOAD DATA LOCAL INFILE 'C:\\Users\\Administrator\\Desktop\\sku11(1).csv' INTO TABLE `db_cube`.`products_sku_temp` FIELDS ESCAPED BY '\\' TERMINATED BY '\t' LINES TERMINATED BY '\r\n' (`sku`)　　另外注意LINES TERMINATED BY '\r\n'，在linux上需要用'\r\n',windows上使用'\n'