Hi there, have run the following query (as a test) on my mysql-php workspace.
ActiveStatus = '1’
INTO OUTFILE '/Users/Macbook/Desktop/csv/prova.csv’
FIELDS ENCLOSED BY '"'
TERMINATED BY ';'
ESCAPED BY '"'
LINES TERMINATED BY ‘\r\n’;
when i try to run it, i get:
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Maybe SQL is wrong too, don’t know, but am sure i first need to set something to MYSQL first.
is there a way to solve this? is there a guide?