The used command is not allowed with this MySQL version

转自：https://blog.51cto.com/imysqldba/1359212

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'

 

补充：可以在my.cnf里的[mysql]中设置 local_infile = 1