擅长:python、mysql、java
<p>因为这是谷歌搜索的第一个结果,我想更新这个问题可能会更好。</p>
<p>从<a href="https://docs.python.org/2/library/sqlite3.html#sqlite3-controlling-transactions">python sqlite docs</a>中可以使用</p>
<pre><code>import sqlite3
persons = [
("Hugo", "Boss"),
("Calvin", "Klein")
]
con = sqlite3.connect(":memory:")
# Create the table
con.execute("create table person(firstname, lastname)")
# Fill the table
con.executemany("insert into person(firstname, lastname) values (?,?)", persons)
</code></pre>
<p>我使用这种方法一次提交了超过50k行插入,而且速度非常快。</p>