#2
tlliqi2016-03-31 23:46
|
程序代码:
mysql>LOAD DATA INFILE 'E:\alimusic\mars_tianchi_user_actions\mars_tianchi_user_actions.csv'
-> INTO TABLE train_info
-> FIELDS TERMINATED BY ','
-> OPTIONALLY ENCLOSED BY '"'
-> lines terminated by '\r\n'
-> (user_id, song_id, gmt_create, action_type, ds);
运行的结果为ERROR 1290 (HY000):The MySQL server is running with the --secure-file-priv option so it cannot execute this statement.-> INTO TABLE train_info
-> FIELDS TERMINATED BY ','
-> OPTIONALLY ENCLOSED BY '"'
-> lines terminated by '\r\n'
-> (user_id, song_id, gmt_create, action_type, ds);