Pymysqlfetchallクエリ結果は辞書を返します



Pymysql Fetchall Query Result Returns Dictionary



import pymysql from pymysql.cursors import DictCursor connect2 = pymysql.connect( host='111.111.111.111', port=3306, db='dbname', user='root', passwd='123', charset='utf8' ) cursor2 = connect2.cursor(DictCursor) # cursor has parameters to pass in, so that the result is in dictionary format, not tuple