博客背景:欲将csv文件导入到MySQL下数据库中进行下一步的变换操作
对此常用的导入语句为load data,基本格式为 :
mysql> LOAD DATA INFILE [path of csv file] INTO TABLE [table name]
结果初次调用就直接报错了:
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
报错是涉及MySQL的服务器权限问题,如下加上LOCAL关键字即可视为从客户主机上读取即可解决该问题
mysql> LOAD DATA LOCAL INFILE [path of csv file] INTO TABLE [table name]
之后选择导入数据到数据表指定字段时还算顺利,直接执行如下指令即可:
mysql> LOAD DATA LOCAL INFILE [path of csv file] INTO TABLE [table name] (column1, column2...)
但在导入时加入了CSV格式处理信息后,我输入如下指令:
mysql> LOAD DATA LOCAL INFILE [path of csv file] INTO TABLE [table name] (column1, column2...) FIELDS TERMINATED BY ',