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)

相关推荐