Richard Nagle wrote:
Need to create a test2.db
with following fields A B C
the data is mostly numerical, however it should be okay
with VARCHAR field? ( this is only a test of speed for importing and
searching )
Next Need to make Field "A" index able.
Then do a import of a text file sqtest.csv
into this new database.
What is the command for importing this in?
Richard,
At a command prompt type:
sqlite3 test2.db
At he sqlite3 prompt type:
create table T(A, B, C);
create index on T(A);
.separator ,
.import 'sqtest.cvs'
You should now a table with your data. Be warned that there are problems
importing CSV data with quote delimiters on the fields (the quotes are
included in the table as part of the field values). You can try a select
to dump your table.
select * from T;
HTH
Dennis Cote
