mySQLdb select formatting?

Question

c.execute("select a, c, d from table")
for row in c:
    print(row)

Whenever I go this, the output is always:

('text field 1', 'text field 2', 'text field 3', 'text field 4')

I've been googling and cannot find the answer, is there a way I can make it like

text field 1, text field 2, text field 3, text field 4

?

Martijn Pieters · Accepted Answer · 2013-02-06 07:39:53Z

3

You printed the whole row, which is a tuple. To print it with a little formatting, you could use ''.join():

', '.join(row)

answered Feb 6, 2013 at 7:39

Martijn Pieters

1.1m325 gold badges4.2k silver badges3.4k bronze badges

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

1 Comment

@RocketDonkey: I just did so! [-_-]~

Mirage · Accepted Answer · 2013-02-06 09:27:29Z

0

or you can use this

from itertools import imap

",".join(imap(str, row))

answered Feb 6, 2013 at 9:27

Mirage

31.7k64 gold badges173 silver badges266 bronze badges