pymysql question

[MRAB]

On 2016-02-18 12:08, tdsperth at gmail.com wrote:
> 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
>
According to this:

MySQL query to get column names?
http://stackoverflow.com/questions/4165195/mysql-query-to-get-column-names

it's possible to get the column names.

You could then build a dict to map a lowercase column name to an actual 
column name.