mysql workbench records limit

I perform an SQL query on a database with MySQL and I get back only the first 1000 rows from 24000 expected. If i export the results to an XML form, I get the first 1000 again. Is there a way to disable that limit and get back all the rows? Otherwise, I will have to merge 24 XML files :/

Answers


Do these steps:

  1. Go to Edit -> Preferences.
  2. Click on the SQL Editor tab.
  3. Under Query Editor, uncheck Limit Rows.

Edit

Workbench Version 6.12 (Mac OS(10.11.3))

  1. Go to Edit -> Preferences.
  2. Click on the SQL Editor tab.
  3. Under SQL Execution, uncheck Limit Rows.

I would recommend simply clicking the "Toggle limitation of the records number" button located right above the results pane. Turning off the limit is not the best approach since the server will have to send all records with every query. Placing a limit on the rows returned is generally a good idea.


Need Your Help

Test loops at the top or bottom? (while vs. do while)

language-agnostic loops while-loop do-while

When I was taking CS in college (mid 80's), one of the ideas that was constantly repeated was to always write loops which test at the top (while...) rather than at the bottom (do ... while) of the ...