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