Exporting query results in MySQL Workbench beyond 1000 records
mysql, mysql-workbench
Solution
It is possible to change the query result row limit, or remove the limit entirely.
Go to Edit → Preferences → SQL Editor (tab). If you can't find Query Results, go to SQL Queries(tab) instead.
Locate the Query Results section and untick the Limit Rows checkbox
Click OK.
Re-run your query.
Problem
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?