title: saving from select into outfile mySQL onto client computer
body: <pre><code>select * INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '/n' from ancestor;
  </code></pre>
  
  <p>So I run this command, and it executes normally. I run it again, and it errors because it says that result.txt already exists. When I check within the tmp folder on my computer, I don't see the file there. I have seen many people run into similar errors, and many people's responses have been that it gets saved on the host server. And it does! Which is fine. But here is the thing. I need it to save on my client computer. How do I make it so it works on the client? Also, the client is running mac os x. Also, the person who uses the client uses workbench and would prefer not to use terminal. Because I know there is the -e command for terminal but I don't know how to replicate that on workbench.</p>