SQLITE入门 逐步讲解SQLITE命令行(二)

可以接着上一步操作，直接向DOS窗口输入.help命令来查看SQLite的所有命令行及解释如下：
F:\>sqlite3
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .help
也可以ctrl+c结束命令，想DOS窗口 输入sqlite3执行后再输入.help命令如下：
F:\>sqlite3
SQLite version 3.6.16
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .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
.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.
.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 on TABLE
.load FILE ?ENTRY?
Load an extension library
.mode MODE ?TABLE?
Set output mode where MODE is one of:
  csv Comma-separated values
  column Left-aligned columns. (See .width)
  html HTML >table< code
  insert SQL insert statements for TABLE
  line One value per line
  list Values delimited by .separator string
  tabs Tab-separated values
  tcl TCL list elements
.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
.rest