Open MatFluor opened 2 years ago
When trying to load a CSV into a table, one might have to define the CSV-Separator used. Litecli throws a Syntaxerror.
in sqlite3 (working)
sqlite> .mode csv sqlite> .separator , sqlite> .import examples/test.csv test sqlite> .schema CREATE TABLE test( "field_a" TEXT, "field_b" TEXT, "field_c" TEXT, "field_d" TEXT, "field_e" TEXT );
in litecli (not working)
csvtest.db> .mode csv Changed table format to csv Time: 0.000s csvtest.db> .separator , near ".": syntax error
When trying to load a CSV into a table, one might have to define the CSV-Separator used. Litecli throws a Syntaxerror.
in sqlite3 (working)
in litecli (not working)