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. We create the table, designate the separator, and import the file.
-
sqlite> create table test (id integer, datatype_id integer, level integer, meaning text);
sqlite> .separator ","
sqlite> .import no_yes.csv test