mysql中将数据库返回结果转为dict

结果:(1, ‘11‘)

self.conn = pymysql.connect(
host=‘xxx‘,
port=3806,
user=‘root‘,
passwd=str(123456),
db = ‘test‘,
charset = "utf8"

)

结果:{‘id‘: 1, ‘name‘: ‘11‘}

self.conn = pymysql.connect(

 host=‘xxx‘,
port=3806,
user=‘root‘,
passwd=str(123456),
db = ‘test‘,
charset = "utf8",
cursorclass=pymysql.cursors.DictCursor

)

相关文章