pymysql question
MRAB
python at mrabarnett.plus.com
Thu Feb 18 07:52:32 EST 2016
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.
More information about the Python-list
mailing list