Remove the limit clause from MySQL Workbench

Question

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

but i'm only getting the first 1000 rows

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?

Answer 1

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.

EDIT:

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

Answer 2

In MYSQL Workbench 6.0 the option can be found at Edit->Preferences->SQL Queries tab.

Answer 3

In MySql Workbench 6.3 this option can be selected from the actual query window:

Answer 4

MySQL Workbench 6.3

Option 1

Query > Limit Rows > Don't Limit

If you change the value here, it will also be updated in the path achievable via the second option.

Option 2

Edit > Preferences...

SQL Editor > SQL Execution > uncheck Limit Rows

If you change the value here, it won't be updated in the path achievable via the first option, but the new value will be considered.