作者：泱泱大国吴 | 来源：互联网 | 2023-05-19 02:54
1.在下载一个windows下shell程序，下载地址：http://www.sqlite.com/sqlite-shell-win32-x86-3070900.zip
2.下载完成后解压得到sqlite3.exe，放置在任意目录；
3.使用方式：
a.打开数据库
- Microsoft Windows XP [版本 5.1.2600]
- (C) 版权所有 1985-2001 Microsoft Corp.
-
- C:\Documents and Settings\socrates.WINXP-DUANYX>cd /d E:\tmp\sqlite_stduy\db
-
- E:\tmp\sqlite_stduy\db>sqlite3.exe sqlite_study.db --参数为要打开的数据库名（存在目录时请带//访问）
- SQLite version 3.7.9 2011-11-01 00:52:41
- Enter ".help" for instructions
- Enter SQL statements terminated with a ";"
- sqlite>
b. 查看命令行帮助：
- 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
- 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.
- .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 show indices for tables
- matching LIKE pattern TABLE.
- .load FILE ?ENTRY? Load an extension library
- .log FILE|off Turn logging on or off. FILE can be stderr/stdout
- .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
- If TABLE specified, only show tables matching
- LIKE pattern TABLE.
- .separator STRING Change separator used by output mode and .import
- .show Show the current values for various settings
- .stats ON|OFF Turn stats on or off
- .tables ?TABLE? List names of tables
- If TABLE specified, only list tables matching
- LIKE pattern TABLE.
- .timeout MS Try opening locked tables for MS milliseconds
- .width NUM1 NUM2 ... Set column widths for "column" mode
- .timer ON|OFF Turn the CPU timer measurement on or off
- sqlite>
c.参考以上命令行帮助即可操作数据库，举例如下：
- sqlite> .databases --查看数据库的存放路径
- seq name file
-
- --- --------------- ----------------------------------------------------------
-
- 0 main E:\tmp\sqlite_stduy\db\sqlite_study.db
-
- sqlite> .tables --查看当前数据库中的表
- tbl_product tbl_product1 tbl_product2 tbl_product3
- sqlite> select * from tbl_product3; --执行SQL语句
- 1|iphone4s
- sqlite> insert into tbl_product3 values('nokia'); --SQL语句出错提示
- Error: table tbl_product3 has 2 columns but 1 values were supplied
- sqlite> insert into tbl_product3 values(2, 'nokia');
- sqlite> select * from tbl_product3;
- 1|iphone4s
- 2|nokia
- sqlite>.mode tabs --设置显示模式（以Tab键做为列间间隔符）
- sqlite> select * from tbl_product3;
- 1 iphone4s
- 2 nokia
- sqlite> .show --查看当前shell的环境变量
- echo: off
- explain: off
- headers: off
- mode: list
- nullvalue: ""
- output: stdout
- separator: "\t"
- stats: off
- width:
- sqlite>.quit --退出数据库
-
- E:\tmp\sqlite_stduy\db>
其他相关操作请参考.help进行。
京公网安备 11010802041100号