ClubFavolosa's SQLite tutor
This pages assumes that you have Linux or Mac OSX and knowledge of the so called Borne Again SHell (BASH).
Windows users need some knowledge of cmd.exe and perhaps batchfiles (text files with extension '.bat').
Everybody who did not do so yet needs to download SQLite
and type on the command line:
Usage: sqlite [OPTIONS] FILENAME [SQL]
FILENAME is the name of an SQLite database. A new database is created
if the file does not previously exist.
-help show this message
-init filename read/process named file
-echo print commands before execution
-[no]header turn headers on or off
-bail stop after hitting an error
-interactive force interactive I/O
-batch force batch I/O
-column set output mode to 'column'
-csv set output mode to 'csv'
-html set output mode to HTML
-line set output mode to 'line'
-list set output mode to 'list'
-separator 'x' set output field separator (|)
-nullvalue 'text' set text string for NULL values
-version show SQLite version