pythoncsv文件变成sqlite表数据_使用Python将CSV文件导入sqlite3数据库表

I have a CSV file and I want to bulk-import this file into my sqlite3 database using Python. the command is ".import .....". but it seems that it cannot work like this. Can anyone give me an example of how to do it in sqlite3? I am using windows just in case.

Thanks

解决方案

import csv, sqlite3

con = sqlite3.connect(":memory:")

cur = con.cursor()

cur.execute("CREATE TABLE t (col1, col2);") # use your column names here

with open('data.csv','rb') as fin: # `with` statement available in 2.5+

# csv.DictReader uses first line in file for column headings by default

dr = csv.DictReader(fin) # comma is default delimiter

to_db = [(i['col1'], i['col2']) for i in dr]

cur.executemany("INSERT INTO t (col1, col2) VALUES (?, ?);", to_db)

con.commit()

con.close()