73

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?

Improve this question

2 Answers 2

Reset to default
104

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

Update:

(Using version 6.3.4.0.828)

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

Improve this answer
4
  • @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
8

Version 6.0 on Mac

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

enter image description here

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

You must log in to answer this question.

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