Backup DB (default "main") 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 information.
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 "main") 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 milliseconds
Set column widths for "column" mode
Turn the CPU timer measurement on or off
Read and execute commands from file , which can contain a mix of SQL statements and meta-commands.
Print commands before execution.
Turn headers on or off.
Stop after hitting an error.
Force interactive 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.
- Based on sqlite3 cheat sheet by richardjh