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 :/
Do these steps:
- Go to Edit -> Preferences.
- Click on the SQL Editor tab.
- Under Query Editor, uncheck Limit Rows.