PY
(real quick example)
CREATE TABLE `users` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `email` TEXT NOT NULL UNIQUE, `name` TEXT NOT NULL );
job@doe.com,Job Doe joe@doe.com,Joe Doe joi@doe.com,Joi Doe jon@doe.com,Jon Doe joy@doe.com,Joy Doe
LOAD MODULES import sqlite3, csv
CONNECT TO DATABASE conn = sqlite3.connect(DBFILE) cursor = conn.cursor()
READ & IMPORT CSV FILE with open(CSVFILE) as demo: reader = csv.reader(demo) for row in reader: cursor.execute("INSERT INTO `users` (`email`, `name`) VALUES (?,?)", row)
COMMIT & CLOSE conn.commit() conn.close()