擅长:python、mysql、java
<p>重新格式化字符串,如下所示:</p>
<pre><code>cursor.execute(
"""
INSERT INTO dbo.someTable([records],
[id], [userid], [originid], [targetid], [targetname],
[start_date], [end_date], [next_offset], [set_id])
values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
""",
(row['records'], row['id'], row['userid'], row['usernanme'],
row['originid'], row['targetid'], row['targetname'],
row['start_date'], row['end_date'], row['next_offset'], row['set_id']))
</code></pre>
<p>而且,参数周围似乎缺少括号。你知道吗</p>