Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

I am getting the SELECT mysql value in tuple form. How can I get it in string form? [duplicate]

Tags:

python

mysql

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
like image 656
Santosh Naidu Avatar asked Dec 29 '25 04:12

Santosh Naidu


1 Answers

cursor.fetchall() return list of tuples. you can access single values from tuple using index.

for y in names:
    print (y[0])
like image 109
deadshot Avatar answered Dec 30 '25 17:12

deadshot