Python: Print only one value of an SQL query result set

Question

from sqlalchemy import create_engine
engine = create_engine('mssql+pymssql://myusername:[email protected]:1433/AQOA_Core')
connection = engine.connect()
result = connection.execute("""SELECT DISTINCT Distributor FROM Product""")
for row in result:
    print row[0]
connection.close()

The above code returns a result set as:

FRANCETV
GAUMONT
M6SND
PATHE
STUDIOCANAL
TF1
WARNER

What if I want to print just one value without changing the query?

Tried print row[0][1], print row[0:1] This was tried to print just the first value FRANCETV

Basically I want to be able to print each one of the values in the result set seperately without making changes to the query.

Answer 1

You can try to access the data by:

connection = engine.connect()
result = connection.execute("""SELECT DISTINCT Distributor FROM Product""")
result_list = result.fetchall()  
result_list[0][0]
connection.close()

Answer 2

If you take a look at the pymssql docs, you'll see the cursor object has a fetchone() method.

with engine.connect() as connection:
    cursor = connection.cursor()
    cursor.execute("""SELECT DISTINCT Distributor FROM Product""")
    first_row = cursor.fetchone()
    print first_row

Answer 3

 file = open("testfile.txt", "w", encoding='utf-8')
 mycursor.execute('SELECT * from COMPANY')
 myresult = mycursor.fetchall()
 counter = 0
 y = 0
   for x in myresult:
   y = 0
   while y < 3:
      print(y)
      file.write("%s\n" % myresult[counter][y])
      y = y + 1
   counter = counter + 1

file.close()

This is what I concluded from the answers above