mycursor.execute("SELECT Name FROM employee_details")
names = (mycursor.fetchall())
for y in names:
print (y)
Result:
('dsf',)
('Gai',)
('egw',)
('qwr',)
('Sam',)
Result I want:
dsf
Gai
egw
qwr
Sam
cursor.fetchall() return list of tuples. you can access single values from tuple using index.
for y in names:
print (y[0])
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With