Exporting query results in MySQL Workbench beyond 1000 records

by

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 untick the Limit Rows checkbox

  3. Click OK.

  4. Re-run your query.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)