Getting brackets while executing query into mysql database using python

Question

I need help!! I have written a python code which queries the database and prints the result in the Linux shell prompt here is the code :

#!/usr/bin/python

import MySQLdb
import sys
import config
import csv     

db = MySQLdb.connect(config.host,config.user,config.password,config.dbname)
cursor=db.cursor()
print "Connected to the Mysql database"
cursor.execute("use " + config.dbname)

cursor.execute('SELECT DISTINCT LEARNER FROM EMS_data LIMIT 5')
result= cursor.fetchall()
print result

db.commit()
cursor.close()

This is what i get :

(("'Fang ",), ("'Nikhil '",), ("'Gavin '",), ("'Vamsi'",), ("'Shah'",))

How to remove these braces..?

You are returning a tuple of tuples; so use a loop to step through the tuple list and print each indiviual item. — Burhan Khalid
– Burhan Khalid, Commented Jun 10, 2013 at 11:25

Ion Scerbatiuc · Accepted Answer · 2013-06-10 11:30:38Z

6

The result returned by cursor.fetchall() is a tuple of tuples containing the fetched data. Each tuple represents a fetched row.

Because you are printing a tuple of tuples, you are seeing the braces. In order to display the data in a prefered format you'll have to iterate over the result and print each row accordingly.

The example below would print each row on a new line, and will separate the columns with a vertical bar:

for row in result:
    print " | ".join(row)

answered Jun 10, 2013 at 11:30

Ion Scerbatiuc

1,1816 silver badges10 bronze badges

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

1 Comment

Rj_N Over a year ago

it is expecting rows are strings and getting exception if it has int.

don't blink · Accepted Answer · 2018-12-03 00:06:31Z

1

The result returned by cursor.fetchall() is a tuple of tuples containing the fetched data. Each tuple represents a fetched row.

1st line of code below will take tuples one by one.
2nd line will print not taken tuple itself, but exactly first element from it (without commas and brackets)

for row in result:
    print(row[0])

edited Dec 3, 2018 at 0:06

answered Nov 29, 2018 at 14:24

don't blink

1011 silver badge13 bronze badges

1 Comment

Ctrl S Over a year ago

You can improve the quality of your answer by explaining what it does and how it solves the issue.

Collectives™ on Stack Overflow

Getting brackets while executing query into mysql database using python

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related