1.在下載一個windows下shell程序,下載地址:http://www.sqlite.com/sqlite-shell-win32-x86-3070900.zip
2.下載完成後解壓得到sqlite3.exe,放置在任意目錄;
3.使用方式:
a.打開數據庫
[html]
- 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. 查看命令行幫助:
[html]
- 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.參考以上命令行幫助即可操作數據庫,舉例如下:
[html]
- 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進行。