I saw always 1000 row retrived from each of my between and And query, even though the condition vary? what is the explanation?

Exactly Tsvetelin Tsonkov Thank you

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... Kind regards, Kev T.