Selecting field by the column name

Asked Sep 22 '16 at 14:37

Active Sep 22 '16 at 15:05

Viewed 31 times

Is there any way to get the issue of a field by its Column name. I need something like this:

import MySQLdb

db = MySQLdb.connect(host="***",    # your host, usually localhost
                     user="***",                     # your username
                     passwd="***",                      # your password
                     db="***")                     # name of the data base
sql="SELECT * FROM t_table"
cur = db.cursor()
cur.execute(sql)
cur.fetchall()[0]['firstName']

table lookslike that (sry i dont know how to create table here):

id |firstname|lastname

1  |Paul     |Peter

Have anyone an idea?

edited Sep 22 '16 at 15:05

asked Sep 22 '16 at 14:37

nicoschuck

1

Are you referring to `Associative Arrays`? Of so it depends heavily on your `db` class implementation to support this. We would need to know which library or db engine you're using to fetch your results. – Torxed Sep 22 '16 at 14:48
@Torxed thanks for the feedback. i added some infos – nicoschuck Sep 22 '16 at 15:07
yes it works. thank u a lot :D – nicoschuck Sep 22 '16 at 15:46

Selecting field by the column name

0 Answers0