.help
View Help Information
.backup ?DB? FILE
Backup database, method:.backup [main|...] filename, the database name can be obtained through the .databases command, generally main, can be omitted, and filename is the disk file name.
.bail ON|OFF
No more continue when an error is encountered, default is OFF
.databases
List databases and files attached to the database
.dump ?TABLE? ...
Save tables to SQL-formatted files, without specifying table names, save them all. If you want to save them to disk, you need to combine the .output command.
.echo ON|OFF
On/off Command line echo
.exit
Exit this command line
.explain ?ON|OFF?
Display the header in a suitable way, and if it is not covered, it is turned on
.header<s> ON;OFF
Whether to display the header, the difference between .explain is not very big
.help
Show help information
.import FILE TABLE
Import tables from files
.indices ?TABLE?
Show index
.load FILE ?ENTRY?
Load an extension library
.log FILE|off
Whether to record logs, the file can be standard output/input
.mode MODE ?TABLE?
To set the output mode, the mode can be as follows:
csv
column left aligned header (see .width)
html Display HTML code
insert SQL Insert Statement
line One value per line
list Values are separated by string
tabs Values separated by tab
tcl TCL list element
.nullvalue STRING
STRING instead of output of NULL value
.output FILENAME
Output to a file, not displayed on the screen
.output stdout
Output to the screen
.prompt MAIN CONTINUE
Replace the default command prompt information, the default is sqlite>
.quit
Exit the command line
.read FILENAME
Execute SQL in FILENAME
.restore ?DB? FILE
Restore data from a file to a table, the default table is main
.schema ?TABLE?
Show CREATE statement
.timeout MS
Try to open the locked table in MS time
.vfsname ?AUX?
Display VFS stack information
.width NUM1 NUM2 ...
Set the width of the column in column mode
.timer ON|OFF
Display CPU time
other:
See the official SQLITE3 command manual
For example, cacheum can free up disk space...
Others:
Execute the SQL statement
--End of File--