Python/mysql : Result into two Lists

Question

我试图使用 Python 脚本和 matplotlib 绘制 MySQL 结果

import MySQLdb
import matplotlib.pyplot as plt

   conn = MySQLdb.connect (host = "localhost",
                           user = "testuser",
                           passwd = "testpass",
                           db = "test")
   cursor = conn.cursor ()
   cursor.execute ("SELECT id,secondid from table limit 10")
   row = cursor.fetchall()
   print "RESULT:", row[0]
   cursor.close ()
   conn.close ()

我将通过像这样的简单传递来绘制这两个列表

id,ts=zip(*row)  #cThis will solve the problem


plt.plot(id,secondid)
plt.grid()

但是我很困惑创建两个列表，因为查询结果是元组列表。请建议。

Answer 1

答案是

id,secondid=zip(*row)