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:
> #which fails because it is upper case in the table
According to this:
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
More information about the Python-list