How to retrieve SQL result column value using column name in Python using MySql data base?

Question

Is there a way to retrieve SQL result column value using column name instead of column index in Python?

result = `select name, deptname from employee;`

I tried below one:

cursor = conn.cursor(MySQLdb.cursors.DictCursor)
cursor.execute("SELECT name, category FROM animal")
result_set = cursor.fetchall()
for row in result_set:
    print "%s, %s" % (row["name"], row["deptname"])

Here I got an error like:

TypeError: tuple indices must be integers, not str

Any help will be awesome?

Neo · Accepted Answer · 2016-05-01 14:17:21Z

2

Actually you are getting what you wanted. You just need to use the row not as a dictionary but as a tuple. That means that the indices are numbers, not strings. Try

print "%s, %s" % (row[0], row[1])

instead

answered May 1, 2016 at 14:17

Neo

3,8162 gold badges24 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

alecxe Over a year ago

Yeah, but the OP specifically asks Is there a way to retrieve SQL result column value using column name instead of column index in Python?..meaning the OP actually wants dictionary access to the table rows.

alecxe · Accepted Answer · 2016-05-01 14:14:04Z

1

You are not correctly specifying that you need a dictionary cursor. Do that when you call the connect() method, set the cursorclass:

import MySQLdb

conn = MySQLdb.connect(user='user', 
                       passwd='password', 
                       db='db_name', 
                       cursorclass=MySQLdb.cursors.DictCursor) 
cursor = conn.cursor()

answered May 1, 2016 at 14:14

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Collectives™ on Stack Overflow

How to retrieve SQL result column value using column name in Python using MySql data base?

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related