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