Querying databases with SQLite

Shell

Start the interactive shell:

sqlite3

Open or create a database:

sqlite3 dbname

Dot-commands

List tables:

.tables

Change output separator (e.g. for tab-delimited):

.separator "\t"

Import data from a file into a table (default separator is ,):

.import /path/to/file table_name