Show Menu

sqlite3 Cheat Sheet by richardjh

A command line interface for SQLite version 3

sqlite3 Meta Commands

.backup ?DB? FILE
Backup DB (default "­mai­n") to FILE
.bail ON|OFF
Stop after hitting an error. Default OFF
.databases
List names and files of attached databases
.dump ?TABLE? ...
Dump the database in an SQL text format.
.echo ON|OFF
Turn command echo on or off
.exit
Exit this program
.explain ?ON|OFF?
Turn output mode suitable for EXPLAIN on or off.
.header(s) ON|OFF
Turn display of headers on or off
.help
Shows this inform­ation.
.import FILE TABLE
Import data from FILE into TABLE
.indices ?TABLE?
Show names of all indices
.load FILE ?ENTRY?
Load an extension library
.log FILE|off
Turn logging on or off. FILE can be stderr­/stdout
.mode MODE ?TABLE?
Set output mode where MODE is one of: csv, column, html, insert, line, list, tabs, tcl
.nullvalue STRING
Print STRING in place of NULL values
.output FILENAME
Send output to FILENAME
.output stdout
Send output to the screen
.prompt MAIN CONTINUE
Replace the standard prompts
.quit
Exit this program
.read FILENAME
Execute SQL in FILENAME
.restore ?DB? FILE
Restore content of DB (default "­mai­n") from FILE
 

sqlite3 Meta Commands contd.

.schema ?TABLE?
Show the CREATE statements
.separator STRING
Change separator used by output mode and .import
.show
Show the current values for various settings
.stats ON|OFF
Turn stats on or off
.tables ?TABLE?
List names of tables
.timeout MS
Try opening locked tables for MS millis­econds
.width NUM1 NUM2 ...
Set column widths for "­col­umn­" mode
.timer ON|OFF
Turn the CPU timer measur­ement on or off

sqlite3 See Also

http:/­/ww­w.s­qli­te.org/
The sqlite­3-doc package.
 

sqlite3 Options

-init file
Read and execute commands from file , which can contain a mix of SQL statements and meta-c­omm­ands.
-echo
Print commands before execution.
-[no]h­eader
Turn headers on or off.
-bail
Stop after hitting an error.
-inter­active
Force intera­ctive I/O .
-batch
Force batch I/O .
-column
Query results will be displayed in a table like form, using whitespace characters to separate the columns and align the output.
-csv
Set output mode to CSV (comma separated values).
-html
Query results will be output as simple HTML tables.
-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.
-separator separator
Set output field separator. Default is '|'.
-stats
Print memory stats before each finalize.
-nullvalue string
Set string used to represent NULL values. Default is '' (empty string).
-version
Show SQLite version.
-vfs name
Use name as the default VFS .
-help
Show help on options and exit.
 

Share This Cheat Sheet!

Favourited by 6 Members:

caroline.artz Theosis dttk sebbu mishin DaveChild

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.