pymsql 查询结果返回字典

Python中让MySQL查询结果返回字典类型的方法

import pymysql
host='localhost'
user='root'
passwd='root'
port=3306
db='test'
db=pymysql.connect(
    host=host,
    user=user,
    passwd=passwd,
    db=db,
    port=port,
    charset='utf8',
    cursorclass = pymysql.cursors.DictCursor
)
cursor=db.cursor()
sql="select * from documents"
try:
    cursor.execute(sql)
    result=cursor.fetchall()
    for i in result:
        for j in i:
            print(j,"=>",i[j])
            print(" ")
except:
    print('error')
db.close()