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?

mysql mysql-workbench
Edit
Report