擅长:python、mysql、java
<p>我实际上没有使用过MySQL,但是<a href="https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html" rel="nofollow">docs</a>似乎表示用multi=True调用<code>cursor.execute</code>只会返回一个迭代器。如果这是真的,那么它实际上不会插入任何东西-您需要调用迭代器上的<code>.next()</code>来实际插入记录。在</p>
<p>它还建议不要将参数与<code>multi=True</code>一起使用:</p>
<blockquote>
<p>If multi is set to True, execute() is able to execute multiple statements specified in the operation string. It returns an iterator that enables processing the result of each statement. However, using parameters does not work well in this case, and it is usually a good idea to execute each statement on its own. </p>
</blockquote>
删除默认参数,太长了,读不下去了。在</p>