Page History
- 2007-Dec-19 06:33 anonymous
- 2007-Dec-19 04:42 anonymous
- 2007-Dec-19 04:40 anonymous
In the following example you will import a comma-delimited csv file into your sqlite database. First create the table, then designate the separator, and finally import the file.
sqlite> create table test (id integer, datatype_id integer, level integer, meaning text); sqlite> .separator "," sqlite> .import no_yes.csv test