On 2016-02-18 12:08, tdspe...@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.
--
https://mail.python.org/mailman/listinfo/python-list
