I imported 3 tables with ~130 million rows in total from some .tsv
files using the SQLite3 .mode tabs
/ .import data.tsv table
commands. This worked pretty well except that SQLite made all the column types TEXT
when a lot of them are numbers. Can I redefine the table or create a new table somehow with the correct column types?
Aucun commentaire:
Enregistrer un commentaire