csv文件写入数据库

mysql: [ERROR] unknown variable ‘secure_file_priv=’

关闭数据库
my.ini

[mysqld]
secure_file_priv = ''

重新启动数据库

win7

LOAD DATA INFILE 'd:\\info.csv'
INTO TABLE finance.info
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
lines terminated by '\r\n'
ignore 1 lines
(url,number,operation);

或者

LOAD DATA INFILE 'd:/info.csv'
INTO TABLE finance.info
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
lines terminated by '\r\n'
ignore 1 lines
(url,number,operation);