The used command is not allowed with this MySQL version
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'
页:
[1]