Last answered:

15 Nov 2022

Posted on:

11 Nov 2022

0

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?

4 answers ( 2 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

13 Nov 2022

3

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...
image.png

Kind regards,

Kev T.

Posted on:

13 Nov 2022

0

Thank you so much Kev! 🌷

Instructor
Posted on:

14 Nov 2022

0

Hi Islam and Kev!
Thanks for reaching out.

@: Kev
Thanks for sharing this piece of information with the Community!

@: Islam
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.
Best,
Tsvetelin

Posted on:

15 Nov 2022

0

Exactly Tsvetelin Tsonkov
Thank you

Submit an answer