title: Exporting query results of more than 1000 rows
body: <p>This question has already been asked <a href="https://stackoverflow.com/questions/10288716/exporting-query-results-in-mysql-workbench-beyond-1000-records">here</a>
  . But the accepted answer does not really answer the question. I've just started working on MySQL Workbench from Teradata. I used to be able to configure Teradata so that when running queries the limit was defaulted to 2,000 but when I exported results to a file the limit was removed automatically. Is there a way to configure MySQL Workbench in the same way without having to manually change the settings back and forth each time I want to export?</p>
  
  <p>For example, I know that I can go edit > preferences > SQL Queries and then set or remove the default Limit. I know that I can remove it each time I need to export the results. </p>
  
  <p>But is there a setting that removes the limit automatically for exported results?</p>
  
  <p>Or is there a way to export the results within the SELECT query so that the resulting full length .CSV file saves to my Desktop (And not the server, as per the answer I linked to above)?</p>