sqlite3 shell
The command-line program that opens a SQLite database file and lets you type SQL and see the results.
In more detail
Run sqlite3 followed by a file name to open a database; each statement runs when you end it with a semicolon. The shell also understands dot commands such as .mode and .headers, which change how it displays results.
Examples
The SQL course runs every example in this shell.sqlite3 shop.dbRelated terms
- SQLite — A small relational database that runs as a library inside your program and keeps the whole database in one file.
- dot command — An instruction to the sqlite3 shell itself, starting with a full stop, that changes the shell rather than the data.
- shell — The program that reads the commands you type, runs them and shows the results; sh and bash are common ones.
Taught in
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling