jeudi 4 juin 2015

SQLite INSERT via Python

I have a table with 55 columns with CDR data. The task is to update the table with new values from .tsv(.csv) file. The simple way is to put '?' 55 times into SQL statement INSERT INTO tbl_name VALUES(?, ? ...., (rows)). Could it be done more elegantly? It's easy to import directly from sqlite3, but it should be done with Python

Aucun commentaire:

Enregistrer un commentaire