CODEWITHSUNDEEP
mysqllimit
Ramy
Ramy

Reputation: 21261

Remove the limit clause from MySQL Workbench

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?

Upvotes: 33

Views: 53811

Answers (5)

Gabriel Lima
Gabriel Lima

Reputation: 11

You can use limit all at the end of the query

Upvotes: 1

John Egbert
John Egbert

Reputation: 5776

In MySql Workbench 6.3 this option can be selected from the actual query window: enter image description here

Upvotes: 6

ROMANIA_engineer
ROMANIA_engineer

Reputation: 56704

MySQL Workbench 6.3

Option 1

Query > Limit Rows > Don't Limit

Query Limit Rows Don't Limit

If you change the value here, it will also be updated in the path achievable via the second option.

Option 2

Edit > Preferences...

Edit Preferences

SQL Editor > SQL Execution > uncheck Limit Rows

SQL Editor SQL Execution

If you change the value here, it won't be updated in the path achievable via the first option, but the new value will be considered.

Upvotes: 9

John Parker
John Parker

Reputation: 54445

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.

MySQL Workbench Preferences

EDIT:

In Workbench 6.0, the "Limit Rows" checkbox stands in "SQL Queries" tab (new tab of the same form).

Upvotes: 53

PrasadK
PrasadK

Reputation: 780

In MYSQL Workbench 6.0 the option can be found at Edit->Preferences->SQL Queries tab.

Upvotes: 1

Related Questions