擅长:python、mysql、java
<p>假设您的<code>row_to_write</code>的项数与<code>PMU</code>的列数完全相同,那么可以使用<code>str.join</code>:<code>','.join(['?']*len(row_to_write))</code>轻松地创建一个<code>?</code>标记的字符串</p>
<pre><code>import sqlite3
conn = sqlite3.connect(':memory:')
c = conn.cursor()
c.execute("create table PMU (%s)" % ','.join("col%d"%i for i in range(50)))
row_to_write = list(range(100,150,1))
row_value_markers = ','.join(['?']*len(row_to_write))
c.execute("INSERT INTO PMU VALUES (%s)"%row_value_markers, row_to_write)
conn.commit()
</code></pre>