Unable to export more than 1000 records (Query results) in MySQL Workbench
By default MySQL Workbench query result shows only 1000 records, so when you Export the table, it exports only 1000 records.
It is possible to change the query result row limit, or remove the limit entirely.
1) Go to Edit → Preferences → SQL Editor (tab). If you can't find Query Results, go to SQL Queries(tab) instead.
2) Locate the Query Results section and uncheck the Limit Rows checkbox
3) Click OK.
4) Re-run your query.
5) Do Export.
No comments:
Post a Comment