我正在使用 Python 提取 MySQL 數據,如下所示。但是我得到如下字符。我不需要數據類型,只需要值 - 我可以這樣做嗎?[[u'Fri', Decimal('3004043')], [u'Mon', Decimal('1450340')], [u'Sat', Decimal('1670562')], [u'Sun', Decimal('2373750')], [u'Thu', Decimal('3116066')], [u'Tue', Decimal('729403')這是查詢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)
添加回答
舉報
0/150
提交
取消