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

)
posted @ 2020-04-23 17:53  cc鱼  阅读(588)  评论(0)  编辑  收藏  举报