擅长:python、mysql、java
<p><code>cursor.execute()</code>需要一个sql语句(作为字符串)和一个可选的值序列,因此它应该是:</p>
<pre><code># this will build a (statement, (values,....)) tuple
args = "INSERT INTO STAGING(ADRESSE_1600 ,
ADRESSE_1601, ADRESSE_1602, ADRESSE_1603)
VALUES ('%s', '%d', '%d', '%s')", (row[i],i)
# so you need positional arguments unpacking:
cursor.execute(*args)
</code></pre>
<p>或者您可以使用:</p>
<pre><code>sql = "INSERT INTO STAGING(ADRESSE_1600 ,
ADRESSE_1601, ADRESSE_1602, ADRESSE_1603)
VALUES ('%s', '%d', '%d', '%s')"
cursor.execute(sql, (row[i],i))
</code></pre>