186
I'm trying to import a csv file to an SQLite table.
Example csv:
1,2
5,6
2,7
Example command:
sqlite> create table foo(a, b);
sqlite> .separator ,
sqlite> .import test.csv foo
Error: test.csv line 1: expected 2 columns of data but found 4
I'm not even sure why it would find four columns with six pieces of data and two columns.