【mysql】MySQLdb返回字典方法

標籤：row   etc   ber   字典   table   number   test   維護   com   

來源：http://blog.csdn.net/zgl_dm/article/details/8710371

 

預設mysqldb返回的是元組，這樣對使用者不太友好，也不利於維護
下面是解決方案

import MySQLdbimport MySQLdb.cursorsconn = MySQLdb.Connect (host = ‘localhost‘, user = ‘root‘ ,passwd = ‘‘, db = ‘test‘, compress = 1,cursorclass = MySQLdb.cursors.DictCursor, charset=‘utf8‘) // <- importantcursor = conn.cursor()cursor.execute ("SELECT name, txt FROM table")rows = cursor.fetchall()cursor.close()conn.close()

for row in rows：
    print row [‘name‘], row [‘txt‘] # bingo!

 

# another (even better) way is:

conn = MySQLdb . Connect (host = ‘ localhost ‘, user = ‘root‘ ,passwd = ‘‘, db = ‘test‘ , compress = 1)cursor = conn.cursor (cursorclass = MySQLdb.cursors.DictCursor)# ...# results by field namecursor = conn.cursor()# ...# ...results by field number

 

 

 

注意：如果同時安裝了PyMySQL和MySQL-python庫，會導致MySQL-python失效，只有pymsql可用

【mysql】MySQLdb返回字典方法