title: SQL into outfile - where is the file stored? (MySQL, Windows)
body: <p>I am using MySQL and would like the results of the following query to be stored in a csv file locally on my machine:</p>
  
  <pre><code>SELECT * INTO OUTFILE 'mysqlresults.csv' FIELDS TERMINATED BY ','OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM table;
  </code></pre>
  
  <p>I have searched for the file and it could not be located anywhere on the disk so it is not in the 'data' directory.</p>