Remove the limit clause from MySQL Workbench

mysql limit
Ramy picture Ramy · Mar 3, 2011 · Viewed 39.4k times · Source

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?

Answer

John Parker picture John Parker · Mar 3, 2011

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

Related questions

Maximum number of records in a MySQL database table

What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to handle this kind of situations? Thx!

Read More
MySQL - UPDATE query with LIMIT

I want to update rows in my table with starting from 1001 to next 1000. I tried with following query: UPDATE `oltp_db`.`users` SET p_id = 3 LIMIT 1001, 1000 This is giving me syntax error. Is this correct? am I doing any mistake …

Read More
Pagination using MySQL LIMIT, OFFSET

I have some code that LIMITs data to display only 4 items per page. The column I'm using has about 20-30 items, so I need to make those spread out across the pages. On the first page, I have: $result = mysqli_…

Read More