Remove the limit clause from MySQL Workbench

I'm running this que开发者_如何学Cry: 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?

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

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.

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

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