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
)