Cheatography
https://cheatography.com
A command line interface for SQLite version 3
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 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.org
Metadata
Favourited By
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets
More Cheat Sheets by richardjh