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?

2 Answers 2


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


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


(Using version

On the menu bar visit Edit -> Preferences. Expand SQL Editor. Select SQL Execution.

In the SELECT Query Results section, you can either uncheck Limit Rows or increase/decrease the Limit Rows Count.

workbench preferences

  • @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, 2012 at 9:21
  • 1
    The SQL Queries tab is named SQL Editor in 5.2.38, and is named SQL Execution in version 6.2.
    – SPRBRN
    Oct 21, 2014 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, 2014 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, 2015 at 18:19

Version 6.0 on Mac

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

enter image description here

  • Yes, works also for windows.
    – Ady96
    Mar 5, 2018 at 0:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.