sqlite3命令详解（中）

文章参照：www.sqlite.org/sqlite.html

在sqlite3中我们可以通过".help"命令来查所有的非SQL命令。

比如，示例4：

sqlite> .help

.help

.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

                                   If TABLE specified, only dump tables matching

                                   LIKE pattern TABLE.

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

                                    With no args, it turns EXPLAIN on.

.genfkey ?OPTIONS?     Options are:

                                      --no-drop: Do not drop old fkey triggers.

                                      --ignore-errors: Ignore tables with fkey errors

                                     --exec: Execute generated SQL immediately

                                         See file tool/genfkey.README in the source

                                          distribution for further information.

.header(s) ON|OFF      Turn display of headers on or off

.help                               Show this message

.import FILE TABLE     Import data from FILE into TABLE

.indices ?TABLE?        Show names of all indices

                                     If TABLE specified, only sh