在MySQL Workbench中导出查询结果超过1000条记录 [英] Exporting query results in MySQL Workbench beyond 1000 records

问题描述

我正在尝试在MySQL Workbench中保存大约1,000,000条记录的查询结果.

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

当我运行SELECT时，仅显示1000条记录(MySQL Workbench的默认限制).我知道我可以更改限制，也可以删除限制，但是我不希望将1,000,000条记录加载到结果面板中(这可能会使我的计算机崩溃?)，但是我确实想将结果保存到文件中.

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.

MySQL Workbench是否允许您将查询结果直接保存到文件中?还是保存整个结果集，而不是保存整个结果集?

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.

1. 转到编辑→偏好设置→ SQL编辑器(标签).如果找不到查询结果，请转至 SQL查询(标签).

1. 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

单击确定.

重新运行查询.

这篇关于在MySQL Workbench中导出查询结果超过1000条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！