MySQL python DBAPI. How to get a dictionary instead of a tuple?

Question

The Python DB API returns a list of tuples when fetchall is called on a executed cursor. If you are working with the _mysql module, fetch_row has a parameter howthat allows you to get a dictionary instead of a tuple. How can I achieve this with the cursor?

Answer 1

Quote from the documentation

DictCursor
    Like Cursor except it returns rows as dictionaries.