擅长:python、mysql、java
<p>如果您对代码的高性能感兴趣,这个答案可能更好。</p>
<p>与<code>excutemany</code>方法相比,下面的<code>execute</code>将快得多:</p>
<pre><code>INSERT INTO mailing_list (name,email) VALUES ('Jim','jim@yahoo.com'),('Lucy','Lucy@gmail.com')
</code></pre>
<p>您可以很容易地修改@Nathan Villaescusa的答案并获得新代码。</p>
<pre><code>cursor.execute("""INSERT INTO mailing_list (name,email) VALUES (%s)""".format(",".join(str(i) for i in rows))
</code></pre>
<p>以下是我自己的测试结果:</p>
<pre><code>excutemany:10000 runs takes 220 seconds
execute:10000 runs takes 12 seconds.
</code></pre>
<p>速度差大约是15倍。</p>