How to remove 1000-row limit in MySQL Workbench queries?

Question

During execution of an SQL Query in MySQL Workbench, the query is automatically limited to 1000 rows. How does one prevent the tool from imposing this limit?

Answer 1

You need to add your own LIMIT clause to then end of your query.

Use a number greater than the possible number of items that will be returned, say LIMIT 100000.

Source: http://wb.mysql.com/?p=230#comment-1279

---

Update:

(Using version 5.2.29CE, not sure how up to date I am):

On the menu bar visit Edit -> Preferences.

Jump to the SQL Editor tab.

In the Query Results sectio at the bottom untick the Limit Rows option.
You can adjust the limit to a higher value from this location as well, if that is preferable.