SQLite 3 cheatsheet

SQLite 3: Display options

6 common SQLite 3 tasks.

Show column headers

Print column names above query results.

.headers on

Format results as an aligned table.

.mode column

Print query results as JSON.

.mode json

Print results as comma-separated values.

.mode csv

Print how long every statement takes.

.timer on

Write results to a file instead of the screen.

.output results.txt