擅长:python、mysql、java
<p>根据<a href="https://docs.oracle.com/cd/E17952_01/connector-python-en/connector-python-api-mysqlcursor-execute.html" rel="nofollow noreferrer">MySQL execute method docs</a>,第一个参数应该是SQL字符串。你知道吗</p>
<p>您正在传递一个元组,以及查询和元组。你知道吗</p>
<p>所以换成:</p>
<pre><code>file = csv.reader(file('20184329:2143.csv'))
sql_insert_table = """INSERT INTO STAGING(ADRESSE_1600 ,
ADRESSE_1601, ADRESSE_1602, ADRESSE_1603)
VALUES ('%s', '%d', '%d', '%s')"""
for row in file:
cursor.execute(sql_insert_table, params=row)
</code></pre>
<p>注意,您可以按原样传递行,因为<code>csv.reader</code>返回字符串列表。你知道吗</p>