Python and MySQL print results

Question

I'm trying to teach myself Python but I've hit a brick wall. I need to get a field from MySQL however when I retrieve the data from the database it comes out odd. That's the code below I use.

cursor1 = db.cursor()
cursor1.execute("select djname from jerryins_djleaderboard.leaderboard where djname = %s", dj)
result = cursor1.fetchall()
print result

It prints out like this:

(('cutecrazygirl88\r\n',)

However I want it to come out as cutecrazygirl88 as it is in the database. Any help would be appreciated. Thank you in advance!

also you might want to store just your data in the db without anyformatting your value has a newline with it. You can remove these for insert using docs.python.org/library/stdtypes.html#str.strip python strip method — dm03514
– dm03514, Commented Sep 3, 2012 at 0:08

Ignacio Vazquez-Abrams · Accepted Answer · 2012-09-03 00:04:23Z

23

fetchall() returns all fields and all rows in the cursor. You will need to iterate over the rows and access the fields in order to get at the data.

for row in result:
  print row[0]

answered Sep 3, 2012 at 0:04

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

1 Comment

Christian Over a year ago

Silly oversight by me. Thank you for your help :)

Jackob King · Accepted Answer · 2019-05-21 15:59:48Z

0

To print everything the table contains with beautifultable:

from beautifultable import BeautifulTable
def function_name(result):
     table=BeautifulTable()
     table.column_headers["DJ Name"]
     for row in result:
          table.append_row(row)
     print(table)

edited May 21, 2019 at 15:59

Jackob King

334 bronze badges

answered Apr 19, 2018 at 11:44

manjuath

1

Collectives™ on Stack Overflow

Python and MySQL print results

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related