Methods for returning MySQL query results to dictionary types in Python

Python's MySQLdb module is a python-connected MySQL module, and the default query results are returned as a tuple type, which can only be accessed through 0,1. Index Access data
Default Connection database:

MySQLdb.connect (Host=host, User=user, passwd=passwd, Db=db, Port=port, charset= ' UTF 8 ')

Copy Code Print:

Copy the code code as follows for the row in Data:print type (row) print row

Execution Result:

Copy Code

The code is as follows: <type ' tuple ' > (1L,)

is a tuple type.
We can do this. Causes the data query result to return the dictionary type, that is, the field = Data
import module

Import Mysqldb.cursors

Add this parameter to the Join function Cursorclass = MySQLdb.cursors.DictCursor such as:

MySQLdb.connect (Host=host, User=user, passwd=passwd, Db=db, Port=port, charset= ' UTF 8 ', Cursorclass = MySQLdb.cursors.DictCursor)

Rerun the script to see the results of the execution:

<type ' dict ' >{' b_id ': 1L}

Get!
Note that if the port is to be specified, the value must be integer if it is connected, otherwise an error will occur!

Methods for returning MySQL query results to dictionary types in Python