litecli
litecli copied to clipboard
".separator" command missing
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