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.db

Related terms

Taught in

References