sqlite3.txt

sqlite3 [options] db_file [sql_command]
  -column // separate columns by space

# Database commands
.tables // show tables
.schema // show databases
.quit
.help
.open file.sqlite // load database
.mode tabs, list, csv, html

# String comparison
= // exact match; fast
LIKE  // allows patters (LIKE 'Test%'); slow
  % // any sequence of >= 0 characters
  _ // any character
IN ('v1', 'v2')

# Show tables
SELECT name FROM sqlite_master WHERE type='table';

# Copy from other database
ATTACH 'src.sql' as src;
INSERT INTO table SELECT * FROM src.table;

# Update values
UPDATE table SET field=value WHERE cond;

# Delete rows
DELETE FROM table WHERE condition