SQLite cheatsheet

-- Turn on headers
> .headers on

-- Turn on line mode
> .mode line

-- Import a CSV
-- WARNING: this doesn't really work with existing tables
> .import --csv <file> <table>

-- List tables
> SELECT name FROM sqlite_master WHERE type='table';

-- See columns of table
> PRAGMA table_info(<table>)

-- Copy from one table to another
INSERT INTO table1(c1, c2) SELECT c1, c2 FROM table2;