pymysql question

[tdsperth at gmail.com]

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