Resolved: Fixed Number of Row retrieved from each of my between and And query
I saw always 1000 row retrived from each of my between and And query, even though the condition vary? what is the explanation?
Hi Islam Elkhateeb,
If you look within the MySQL Workbench, there is a DROP DOWN option that allows you to choose the number of results returned. When working on big data sets, you may not wish to have the 'entire' results listing generated (expect there may be some time savings\efficiencies, so you can set the 'Limit Rows' to any of the selections from the Drop Down option.
You can also set the DEFAULT for this through Edit\Preferences\SQL Editor\SQL Execution - Select Query Results (Limit Rows \ Limit Rows Count). Screen shot below shows location of Drop Down option...
Hi Islam and Kev!
Thanks for reaching out.
Thanks for sharing this piece of information with the Community!
Kev said it all. You need to choose the option
Don't Limit in order to obtain all records in the result set.
Hope this helps.