Exporting query results in MySQL Workbench beyond 1000 records
Exporting query results in MySQL Workbench beyond 1000 records explains you can export more than 1000 rows which are returned by MySQL Workbench. You have option to change the limit of rows returned by MySQL Workbench to 10,30,50,100,200 or to 50000. Also you can choose No Limit then the query will return you all the results from a table. You always have a option to set the Limit Rows by going to preferences.
MySQL Workbench Tutorial - Export query results in MySQL Workbench beyon 1000 rows