可以接着上一步操作,直接向DOS窗口输入.help命令来查看sqlite的所有命令行及解释如下:
F:/>sqlite3
sqlite version 3.6.16
Enter ".help" for instructions
Enter sql statements terminated with a ";"
sqlite> .help
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
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 |