Show Menu

sqlite3 Cheat Sheet by

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
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 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
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
Replace the standard prompts
Exit this program
.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 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

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.
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.
-separator separator
Set output field separator. Default is '|'.
Print memory stats before each finalize.
-nullvalue string
Set string used to represent NULL values. Default is '' (empty string).
Show SQLite version.
-vfs name
Use name as the default VFS .
Show help on options and exit.

Share This Cheat Sheet!

Favourited by 6 Cheatographers:

caroline.artz Theosis dttk sebbu mishin DaveChild


No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.