Exporting query results in MySQL Workbench beyond 1000 records

mysql mysql-workbench
think.arthur picture think.arthur · Apr 23, 2012 · Viewed 52k times · Source

I'm trying to save a query result of about 1,000,000 records in MySQL Workbench.

When I run the SELECT, only 1000 records shows up (MySQL Workbench's default limit). I know I can change the limit, or remove the limit, but I don't want 1,000,000 records to be loaded into the result panel (which might crash my computer?), but I do want to save the results to a file.

Does MySQL Workbench let you save the results of a query directly to a file? Or save the whole result set instead of the 1,000?

Answer

user86614 picture user86614 · Oct 13, 2012

It is possible to change the query result row limit, or remove the limit entirely.

  1. Go to Edit → Preferences → SQL Editor (tab). If you can't find Query Results, go to SQL Queries(tab) instead.

  2. Locate the Query Results section and untick the Limit Rows checkbox

  3. Click OK.

  4. Re-run your query.

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More