SQLite Commands
(Below commands all are called SQLite dot commands other than SQL dot command for
If you want retrieve all SQL DOT COMMANDS type " . help
You will get below output
Command
|
Description
|
.
|
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. If TABLE specified, only dump tables matching LIKE pattern TABLE.
|
.
|
Turn command echo on or off
|
.
|
Exit SQLite prompt
|
.
|
Turn output mode suitable for EXPLAIN on or off. With no
|
.
|
Turn display of headers on or off
|
.
|
Show this message
|
.
|
Import data from FILE into TABLE
|
.
|
Show names of all indices. If TABLE specified, only show indices for tables matching LIKE pattern TABLE.
|
.
|
Load an extension library
|
.
|
Turn logging on or off. FILE can be stderr/stdout
|
.
|
Set output mode where MODE is one of:
|
.
|
Print STRING in place of NULL values
|
.
|
Send output to FILENAME
|
.
|
Send output to the screen
|
.
|
Print literal STRING
|
.
|
Replace the standard prompts
|
.
|
Exit SQLite prompt
|
.
|
Execute SQL in FILENAME
|
.
|
Show the CREATE statements. If TABLE specified, only show tables matching LIKE pattern TABLE.
|
.
|
Change separator used by output mode and
|
.
|
Show the current values for various settings
|
.
|
Turn
|
.
|
List names of tables matching a LIKE pattern
|
.
|
Try opening locked tables for MS milliseconds
|
.
|
Set column widths for "column" mode
|
.
|
Turn the CPU timer measurement on or off
|
No comments: