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?
How to remove 1000-row limit in MySQL Workbench queries
MySQL
Related Solutions
Typically you build your schema in MySQL and you either let the app using the database populate itself with data over time, or you'll be importing existing data from an existing system using some level of scripting or programming, possibly/probably an extension of whatever system will be using the database.
I suppose certain test cases may exist where you'd want to use Workbench to generate some data; or maybe you want to populate some lookup tables at schema creation, but I'd think there would be better/easier ways...Regardless, MySQL's official documentation for this is here.
Looks like your "Add Entry" button is off screen for some reason.
Best Answer
You need to add your ownLIMITclause 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-1279Update:
(Using version 5.2.29CE, not sure how up to date I am):
On the menu bar visit
Edit->Preferences.Jump to the
SQL Queriestab.In the
Query Resultssection at the bottom untick theLimit Rowsoption.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. ExpandSQL Editor. SelectSQL Execution.In the SELECT Query Results section, you can either uncheck Limit Rows or increase/decrease the Limit Rows Count.