https://cheatography.com///richardjh/cheat-sheets/sqlite3/

sqlite3 Meta Commands

.backup ?DB? FILE

Backup DB (default "main") 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 information.

.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 "main") 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 milliseconds

.width NUM1 NUM2 ...

Set column widths for "column" mode

.timer ON|OFF

Turn the CPU timer measurement on or off

sqlite3 See Also

http://www.sqlite.org/
The sqlite3-doc package.

sqlite3 Options

-init file

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

-echo

Print commands before execution.

-[no]header

Turn headers on or off.

-bail

Stop after hitting an error.

-interactive

Force interactive 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.

Created By

richardjh
richardjh.org

Metadata

Languages: English

Published: 13th May, 2012
Last Updated: 12th May, 2016
Rated: 5 out of 5 stars based on 10 ratings

Favourited By

Comments

No comments yet. Add yours below!

Add a Comment

Related Cheat Sheets

Essential MySQL Cheat Sheet

More Cheat Sheets by richardjh

LSI Logic MegaRAID Cheat Sheet

RedBeanPHP Class Reference Cheat Sheet

rsync Cheat Sheet