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

最新推荐文章于 2020-11-03 21:08:21 发布

转载最新推荐文章于 2020-11-03 21:08:21 发布 · 935 阅读

文章标签：

#sqlite #output #sql #extension #file #dos

VC+SQLite 专栏收录该内容

22 篇文章

订阅专栏

本文介绍了在DOS环境下使用SQLite命令行的基本操作方法，包括启动SQLite、查看帮助信息、执行SQL命令等。此外还详细列举了SQLite提供的各种命令行工具，如备份数据库(.backup)、导入数据(.import)、设置输出模式(.mode)等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

可以接着上一步操作，直接向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