How to remove 1000-row limit in MySQL Workbench queries?
Problem
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?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: How to remove 1000-row limit in MySQL Workbench queries?
You need to add your own clause to then end of your query. Use a number greater than the possible number of items that will be returned, say . 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 -> . Jump to the tab. In the section at the bottom untick the 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 …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix