MySQL Connector/Python Release Notes
rows = cursor.fetchmany(size=1)
This method fetches the next set of rows of a query result and returns a list of tuples. If no more rows are available, it returns an empty list.
The number of rows returned can be specified using the
size argument, which defaults to one. Fewer
rows are returned if fewer rows are available than specified.
You must fetch all rows for the current query before executing new statements using the same connection.