mysqldb按字典方式取数据

1，

conn=MySQLdb.Connect(host='localhost',user='root',passwd='',db='test',compress=1,cursorclass=MySQLdb.cursors.DictCursor)

cursor=conn.cursor()

2,

c = self.db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
c.execute(query)
rows = c.fetchall()

 

3,

defFetchOneAssoc(cursor) :

    data = cursor.fetchone()

    if data == None :

        return None

    desc = cursor.description

 

    dict = {}

    for (name, value) in zip(desc, data) :

        dict[name[0]] = value

    return dict

 

4,

cursor.execute('select sum(id) as sumid from tb;')

key为‘sum(id)’

cursor.execute('select sum(id) as sid as sumid from tb;')

key为‘sid’