How to retrieve the values from the database with column name using python script?

Question

I need to retrieve values from the database for the column names specified. The below code I've tried,

import pyodbc

def get_db_data():
    cursor = getConnection.cursor()
    cursor.execute("select * from student")
    return cursor

cur = get_db_data()
for row in cur.fetchall():
    print(row["student_name"])

I'm facing below error

TypeError: row indices must be integers, not str

How to achieve this?

blhsing · Accepted Answer · 2018-09-10 05:14:55Z

1

If you want to access a column by name, you should specify it as an attribute of the row rather than an index:

for row in cur.fetchall():
    print(row.student_name)

answered Sep 10, 2018 at 5:14

blhsing

109k9 gold badges88 silver badges132 bronze badges

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

Comments

Ashish · Accepted Answer · 2018-09-10 05:15:54Z

0

As per the pyodbc documentation "Row objects are similar to tuples, but they also allow access to columns by name". You can try row[0] or row.student_name (Assuming column index for student_name is 0)

import pyodbc

def get_db_data():
    cursor = getConnection.cursor()
    cursor.execute("select * from student")
    return cursor

cur = get_db_data()
for row in cur.fetchall():
    print(row[0])

answered Sep 10, 2018 at 5:15

Ashish

6434 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to retrieve the values from the database with column name using python script?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related