擅长:python、mysql、java
<p>也许是这样的?当然没有经过测试。在</p>
<pre><code>def importCSVToTable(conn, filename, table, columns)
with open(getPathTo(filename), 'r') as csvfile:
reader = csv.DictReader(csvfile)
records = []
for row in reader:
for col in columns:
records.append(row[col])
conn.executemany("INSERT INTO comparison (" + ','.join(columns) + ") VALUES ("+ ','.join(["?"]*columns.length) +");", records)
conn.commit()
</code></pre>