<p>我一直收到错误“AttributeError:'Cursor'object has no attribute'fetchAll'”。我的<code>rowCount</code>是451,所有查询都正常。在</p>
<p>我已经研究过这个问题,大多数错误都涉及到对<code>cursor.execute()</code>的返回值调用<code>fetchAll()</code>,但这不是我要做的。在</p>
<pre><code>#initialize cursors
presswiseCursor = presswiseConnection.cursor()
localCursor = localConnection.cursor()
#products
#initialize table
localCursor.execute("DROP TABLE IF EXISTS products;")
localCursor.execute("CREATE TABLE products (id INT NOT NULL, description VARCHAR(255));")
#get data from presswise
rowCount = presswiseCursor.execute("SELECT DISTINCT id, description FROM list_product;")
print(rowCount)
rows = presswiseCursor.fetchAll()
#add data to local
for row in rows:
localCursor.execute(f'INSERT INTO products (id, description) VALUES({row[0]}{row[1]})')
</code></pre>
<p>我希望遍历查询的结果,并在以前使用过这种精确的技术。我的代码怎么了?在</p>