pymysql question

tdsperth at gmail.com tdsperth at gmail.com
Thu Feb 18 07:08:53 EST 2016


Hi All

I have many mysql tables in a conversion I am doing - the table field names are a mixture of lower case and upper case - do I have to covert all to one case to over come Python not finding the field.

rows ocur.fetchall()
for row in rows:
    print(row['newname']) 
    #which fails because it is upper case in the table


Cheers

Colin




More information about the Python-list mailing list