How to remove extra commas when retrieving data from mysql using python

Question

I'm trying to retrieve some data stored in a mysql table and the output has some additional commas which I don't need.

>>> cursor.execute("SELECT REMOTE_INT FROM R3")
2L
>>> x = cursor.fetchall()
>>> x
((u'xe-0/0/0',), (u'xe-0/0/1',))
>>> x[0]
(u'xe-0/0/0',)
>>> x[1]
(u'xe-0/0/1',)
>>>

Also any suggestions on removing the 'u'? I want to be able to use these values of x in other parts of the script.

The commas are not 'extra commas' - they're indications that the object you're getting back is a tuple (or tuple of tuples in this case) and your result is the first item in the tuple. The u indicates the data is a unicode string; it won't stop you from using the data anywhere else in the code. — ChidG
– ChidG, Commented Mar 8, 2017 at 5:47
Thanks for the feedback. I understand its a tuple but i wasnt sure how to use the value in my script because of the additional commas. But i think i have the answer now. — svijay
– svijay, Commented Mar 8, 2017 at 7:18

e4c5 · Accepted Answer · 2017-03-08 02:12:53Z

6

As per the fetchall documentation.

The method fetches all (or all remaining) rows of a query result set and returns a list of tuples. If no more rows are available, it returns an empty list.

I am not a big fan of fetchall and would like to suggest that you use fetchone or use the cursor as an iterator. however all of these methods still return a tuple.

You can convert the tuple returned to you into a simple list by doing

[ x[0] for x in cursor.fetchall()]

This effectively 'removes the extra comma'

answered Mar 8, 2017 at 2:12

e4c5

53.9k11 gold badges110 silver badges139 bronze badges

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

1 Comment

svijay Over a year ago

Done! Thanks for the tip!

Collectives™ on Stack Overflow

How to remove extra commas when retrieving data from mysql using python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related