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