SQLite

Backup DB (default "­mai­n") to FILE

Stop after hitting an error. Default OFF

List names and files of attached databases

Dump the database in an SQL text format.

Turn command echo on or off

Exit this program

Turn output mode suitable for EXPLAIN on or off.

Turn display of headers on or off

Shows this inform­ation.

Import data from FILE into TABLE

Show names of all indices

Load an extension library

Turn logging on or off. FILE can be stderr­/stdout

Set output mode where MODE is one of: csv, column, html, insert, line, list, tabs, tcl

Print STRING in place of NULL values

Send output to FILENAME

Send output to the screen

Replace the standard prompts

Exit this program

Execute SQL in FILENAME

Restore content of DB (default "­mai­n") from FILE

Show the CREATE statements

Change separator used by output mode and .import

Show the current values for various settings

Turn stats on or off

List names of tables

Try opening locked tables for MS millis­econds

Set column widths for "­col­umn­" mode

Turn the CPU timer measur­ement on or off

Read and execute commands from file , which can contain a mix of SQL statements and meta-c­omm­ands.

Print commands before execution.

Turn headers on or off.

Stop after hitting an error.

Force intera­ctive I/O .

Force batch I/O .

Query results will be displayed in a table like form, using whitespace characters to separate the columns and align the output.

Set output mode to CSV (comma separated values).

Query results will be output as simple HTML tables.

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

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

Set output field separator. Default is "|".

Print memory stats before each finalize.

Set string used to represent NULL values. Default is (empty string).

Show SQLite version.

Use name as the default VFS .

Show help on options and exit.