SQLite: Formatting Query Results

—

Connect to database:

sqlite3 <database-filename>

Turn on headers (default: off)

.headers on|off

Select mode (default: list)

.mode ascii box column csv html insert json line list markdown qbox quote table tabs tcl

Run your query

Comments