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
.restore ?DB? FILE	Restore content of DB (default "main") from FILE
.schema ?TABLE?	Show the CREATE statements
.separator STRING	Change separator used by output mode and .import
.show	Show the current values for various settings
.tables ?PATTERN?	List names of tables matching a LIKE pattern
.timeout MS	Try opening locked tables for MS milliseconds
.width NUM NUM ...	Set column widths for "column" mode

转载于:https://www.cnblogs.com/zhaiqianfeng/archive/2012/07/10/4616832.html