mysql只能查询出1000条数据,在MySQL Workbench中导出查询结果超过1000条记录

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?

解决方案

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.