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:


sqlite -help
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.
OPTIONS include:
   -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