从MySQL Workbench删除limit子句 [英] Remove the limit clause from MySQL Workbench

问题描述

我正在运行以下查询:select * from schema.table

I'm running this query: select * from schema.table

但是我只得到前1000行

but i'm only getting the first 1000 rows

我在输出窗口中看到我的select语句附加了一个LIMIT子句.有没有办法关闭默认限制?

i see in the output window that there was a LIMIT clause appended to my select statement. Is there a way to turn off the default limit?

推荐答案

您可以切换 MySQL Workbench 通过应用程序首选项(编辑"菜单->首选项...")中的"SQL编辑器"标签.

You can toggle the LIMIT clause added by MySQL Workbench via the SQL Editor tab within the application preferences (Edit menu -> Preferences...).

只需取消选中查询结果"部分中的限制行"选项，如下图所示.

Simply un-check the "Limit Rows" option within the Query Results section as pictured below.

在Workbench 6.0中，限制行"复选框位于"SQL查询"选项卡(具有相同形式的新选项卡)中.

In Workbench 6.0, the "Limit Rows" checkbox stands in "SQL Queries" tab (new tab of the same form).

这篇关于从MySQL Workbench删除limit子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！