Python: How to format PYODBC Query Output

Question

I am querying from a database using PYODBC as below:

cursor.execute("SELECT Distinct country from dbo.purchases")

for row in cursor.fetchall():
    print row

The Result of the script is as so:

('Taiwan', )
('Japan', )

How can I format the pyodbc output query to just:

Taiwan
Japan

Logan Bertram · Accepted Answer · 2018-03-21 17:17:07Z

1

The result is a tuple, so print row[0].

answered Mar 21, 2018 at 17:17

Logan Bertram

1,9521 gold badge18 silver badges22 bronze badges

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

1 Answer 1