SQL into outfile - where is the file stored? (MySQL, Windows)

Question

I am using MySQL and would like the results of the following query to be stored in a csv file locally on my machine:

SELECT * INTO OUTFILE 'mysqlresults.csv' FIELDS TERMINATED BY ','OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM table;

I have searched for the file and it could not be located anywhere on the disk so it is not in the 'data' directory.

Answer 1

Be default it stored in the MySQL's data directory. And you can check your data directory by command:

show variables like 'datadir';

You can't store it locally with this command running on remote server, you need to download the file from the server.

You can also use this command:

SELECT * FROM table INTO OUTFILE 'mysqlresults.csv' FIELDS TERMINATED BY ','OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' ;