sqlite3

sqlite3 is a terminal-based front-end to the SQLite library that can evaluate queries interactively and display the results in multiple formats. sqlite3 can also be used within shell scripts and other applications to provide batch processing features.

Documentation

• man 1 'sqlite3' [EN]

Syntax

sqlite3 [PARAMETER ...] [FILE] [SQL]

Parameters

-echo

Print commands before execution.

-[no]header

Turn headers on or off.

-init FILE

Read and execute commands from FILE, which can contain a mix of SQL statements and meta-commands.

-line

Query results will be displayed with one value per line, rows separated by a blank line. Designed to be easily parsed by scripts or other programs.

-list

Query results will be displayed with the separator (|, by default) character between each field value. The default.

Examples

1 pages found:

• /home/alex/dev/sqlite.sh (1)