Shell of sqlite3 (1)
Sqlite3.exe is a tool for SQLite to access the database, in the form of command lines.
There are two types of shell commands. The first is the shell command, which starts with a point. The second is the SQL command used to manage the current database, ending with a semicolon.
Shell commands are divided into the following types: control data display mode; Set shell to read and display data; other system control commands
Common Display Mode Control commands:
. Header on | off: Specifies whether to display the column name of the data table.
. Indices table: displays all column names in the table.
. Mode mode: Set the display mode of the data table. The default value is list, and the string set by the. Separator command is used to separate characters (the default value is | ). We prefer the column format.
. Nullvalue string: string is used to fill the data with null values. The default value is an empty string, that is, nothing is displayed.
. Tables pattern: displays tables in pattern.
. Width num...: Set the data display width when it is displayed in column mode.
. Output Filename | stdout: Set the form of data output: standard output of a file or screen.
. Read filename: Read the SQL statement from the file
Other System Control commands:
. Databases: displays the currently matched database names
. Table: displays all tables in the current database.
. Help: displays shell help information.
. Show: display the current shell setting parameters
. Quit and. Exit: Exit Shell
Reference: http://www.sqlite.org/sqlite.html