willy5943
Importing rows from csv
Hey guys, hope you're doing well. So I'm trying to import rows from a local csv file to my MySQL db using this command:
LOAD DATA INFILE "./users.csv"
INTO TABLE users
COLUMNS TERMINATED BY ';';
but I get the following error:
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
How can I do it without manually inserting the values one by one, or writing a script to do it?
8 replies