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

Leave a Reply

Your email address will not be published. Required fields are marked *