jeudi 5 novembre 2015

Redefining imported table schema in SQLite3

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