New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

".separator" command missing #123

Open

MatFluor opened this issue Dec 16, 2021 · 0 comments

MatFluor commented Dec 16, 2021 •

edited

Loading

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

The text was updated successfully, but these errors were encountered:

MatFluor changed the title ~~".seperator" command missing~~ ".separator" command missing

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment