Summary
In this chapter, we have covered how to retrieve different sets of data using MySQL for Python. We have seen:
Situations in which record-by-record retrieval is desirable
How to use iteration to retrieve sets of records in smaller blocks
How to create iterators and generators in Python
When to use
fetchone()
and when to usefetchmany()
In the next chapter, we will look at how to handle multiple MySQL inserts.