dot command
An instruction to the sqlite3 shell itself, starting with a full stop, that changes the shell rather than the data.
In more detail
Dot commands are not SQL and do not end with a semicolon. Common ones are .mode column with .headers on, which line results up under their column names, and .mode list, which separates values with vertical bars.
Examples
.mode column.headers onRelated terms
- sqlite3 shell — The command-line program that opens a SQLite database file and lets you type SQL and see the results.
Taught in
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling