python和mysql一样吗_Python，MySQL和一个奇怪的

我有一个错误，我不知道如何修复甚至复制：query = "SELECT id, name FROM names ORDER BY id"

results = database.execute(query)

其中，Database类包含：

^{pr2}$

打开数据库连接的方法如下：self.db = MySQLdb.connect(

host=mysqlHost,

user=mysqlUser,

passwd=mysqlPasswd,

db=mysqlDB

)

这是错误的堆栈跟踪：File "foo.py", line 169, in application results = config.db.execute(query)

File "Database.py", line 52, in execute

return cursor.fetchall()

File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 340, in fetchall

self._check_executed()

File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 70, in _check_executed

self.errorhandler(self, ProgrammingError, "execute() first")

File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler

raise errorclass, errorvalue

ProgrammingError: execute() first

你知道为什么会这样吗？我该怎么解决它？我在网上搜索，发现原因可能是有两个光标，但我只有一个。在