Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #103111
| From | MRAB <python@mrabarnett.plus.com> |
|---|---|
| Newsgroups | comp.lang.python |
| Subject | Re: pymysql question |
| Date | 2016-02-18 12:52 +0000 |
| Message-ID | <mailman.247.1455799968.22075.python-list@python.org> (permalink) |
| References | <0b27ecb5-4a3e-46dc-a83c-5ce806f46051@googlegroups.com> |
On 2016-02-18 12:08, tdsperth@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.
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
pymysql question tdsperth@gmail.com - 2016-02-18 04:08 -0800 Re: pymysql question MRAB <python@mrabarnett.plus.com> - 2016-02-18 12:52 +0000 Re: pymysql question Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2016-02-18 22:06 -0500
csiph-web