How to use fetchmany() to fetch the next set of results?
<p>I want to fetch a hundred of results from MySql using fetchmany(100) in Python. But I am wondering if there's a way to fetch the next set of results in case what I want is not available in the fetched results. So it will be something like, fetch the next 100 results. </p>

<p>Is this possible? And if yes then how can it be done?!</p>