Menu
I'm running this query: select * from schema.table
but i'm only getting the first 1000 rows
i see in the output window that there was a LIMIT clause appended to my select statement. Is there a way to turn off the default limit?
223
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.
You can easily change this limit by going to MySQL Workbench >> Edit >> Preferences >> SQL Queries tab. Over here you will option to Limit Rows. You can set this to very high value or uncheck the option. When you uncheck that option, it will retrieve all the rows from a query (equivalent to no limits).
The MySQL LIMIT ClauseThe LIMIT clause is used to specify the number of records to return. The LIMIT clause is useful on large tables with thousands of records. Returning a large number of records can impact performance.
To get only the specified rows from the table, MySQL uses the LIMIT clause, whereas SQL uses the TOP clause, and Oracle uses the ROWNUM clause with the SELECT statement.
You can toggle the LIMIT clause added by MySQL Workbench via the SQL Editor tab within the application preferences (Edit menu -> Preferences...).
Simply un-check the "Limit Rows" option within the Query Results section as pictured below.
EDIT:
In Workbench 6.0, the "Limit Rows" checkbox stands in "SQL Queries" tab (new tab of the same form).
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
