<p>编辑:
这个问题令人难以置信。我现在已经设法用时间。睡觉(0.01),但我不明白为什么我应该从较慢的执行时间中获益。在</p>
<p>在MySQL 1.0.7 connector for python3.23中迭代游标时出现问题。在</p>
<p>除非print()每次迭代的结果(这既愚蠢又耗时),否则我将引发以下错误:</p>
<blockquote>
<p>raise errors.InterfaceError(errno=2013)
mysql.connector.errors.InterfaceError: 2013: Lost connection to MySQL
server during query</p>
</blockquote>
<p>有什么想法吗?在</p>
<p>代码是微不足道的thusfar:</p>
<pre><code>self.config = {'user': user,'password': password,'host': host,'database':
database,'raise_on_warnings': True}
self.data = []
self.clickcnx = mysql.connector.connect(**self.config)
self.clickcursor = self.clickcnx.cursor()
query = "SELECT table1, table2, table3 FROM `db`-tables;"
self.clickcursor.execute(query)
for item in self.clickcursor:
print(item) #this is the strange line that I need!
self.data.<a href="https://www.cnpython.com/list/append" class="inner-link">append</a>(item)
self.clickcnx.close()
</code></pre>