title: Export query result mysql Terminal Mac
body: <p>I am trying to export the results of an <code>SQL</code> query generated via<code>Terminal</code> on a <code>Mac</code> (when I try the same procedure within <code>MAMP</code> it will only export about 200 results before it gives an error message, so if I have 1000 results having to do it 5 times is a pain).</p>
  
  <p>Based on questions asked here I have tried permutations of</p>
  
  <pre><code>SELECT `WhateverINeed`
  FROM `1911` 
  INTO OUTFILE 'AnotherTest.csv'
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n';
  </code></pre>
  
  <p>So while this 'works' – <code>Query OK, 729 rows affected</code> – the file I want to create AnotherTest.csv does not appear anywhere on my system that I can see.</p>