python unicode formatting from SQL

Question

I am extracting MySQL data with Python like below. But I get characters like below. I don't want the data types, just the values - can I do it?

[[u'Fri', Decimal('3004043')], [u'Mon', Decimal('1450340')], [u'Sat', Decimal('1670562')], [u'Sun', Decimal('2373750')], [u'Thu', Decimal('3116066')], [u'Tue', Decimal('729403')

Here is the query

mycursor = mydb.cursor()

mycursor.execute("SELECT day, sum(interactionCount) as ic FROM tw_posts group by day")

posts = []
for x in mycursor:
  day = x[0]
  ic = x[1]
  inner = [day, ic]
  posts.append(inner)

print(posts)

ipj · Accepted Answer · 2020-07-18 19:11:37Z

1

Try using:

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

answered Jul 18, 2020 at 19:11

ipj

3,5981 gold badge17 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

python unicode formatting from SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related