Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 66 down vote accepted

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.



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

On the menu bar visit Edit -> Preferences.

Jump to the SQL Queries tab.

In the Query Results section 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.

share|improve this answer
Thank you, @DMA57361 – Brian Hooper Feb 1 '11 at 13:11
@BOB: You might actually want to post this as your own answer - its substancially different from the original answer, and well, this worked at some point – Journeyman Geek Nov 22 '12 at 9:21
The SQL Queries tab is named SQL Editor in 5.2.38, and is named SQL Execution in version 6.2. – SPRBRN Oct 21 '14 at 9:45
thanks for including both the SQL way and the menu way, I used the SQL way for a one-time export. – Kmeixner Dec 22 '14 at 22:47
Thanks for the clear, concise answer. This works exactly as specified (as of November 22, 2012 edit) for MySQL Workbench 6.0. – Xynariz Feb 12 '15 at 18:19

Version 6.0 on Mac

Menubar->Query->Limit Rows->Don't Limit

enter image description here

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .