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.{linebreak}

_: sqlite> create table test (id integer, datatype_id integer, level integer, meaning text);{linebreak}
_: sqlite> .separator ","{linebreak}
_: sqlite> .import no_yes.csv test