This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
fuss:sqlite [2016/02/15 11:49] – office | fuss:sqlite [2022/04/19 08:28] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Importing Delimited File ====== | ||
+ | |||
+ | To import a file called '' | ||
+ | |||
+ | <code sql> | ||
+ | sqlite> create table csvdata (id integer, datatype_id integer, level integer, meaning text); | ||
+ | sqlite> .separator "," | ||
+ | sqlite> .import csvdata.csv test | ||
+ | </ | ||
+ | |||
+ | ====== Showing Headers ====== | ||
+ | |||
+ | To show the column headers when issuing a command issue: | ||
+ | < | ||
+ | .headers ON | ||
+ | </ | ||
+ | |||
+ | In order to make sqlite always show the headers, add '' | ||
+ | |||
+ | ====== Avoiding Locking Issues for SQLite databases on NFS Mounts ====== | ||
+ | |||
+ | As per the FAQ question on the [[https:// | ||
+ | |||
+ | One workaround is to mount the NFS share with the '' | ||
+ | |||
+ | A different option would be to just switch over to NFSv4 (with or without Kerberos) that takes care of this issue and synchronizes locks. NFSv4 is supported in recent versions of FreeBSD by passing '' | ||