pymysql question

Newsgroups	comp.lang.python
Date	2016-02-18 04:08 -0800
Message-ID	<0b27ecb5-4a3e-46dc-a83c-5ce806f46051@googlegroups.com> (permalink)
Subject	pymysql question
From	tdsperth@gmail.com

Show all headers | View raw

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


Cheers

Colin

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

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