SQLite的Slogan : Small. Fast. Reliable. Choose any three.
SQLite官網:https://www.sqlite.org/
SQLite Download Page : https://www.sqlite.org/download.html
在SQLite的下載頁面,以搜尋的方式找到所需作業系統的對應版本:
以下載 sqlite-tools-win32-x86-3290000.zip 為例
透過7-zip提供的CRC SHA 檔案驗證功能,計算所下載檔案的SHA1值:
(只要能計算SHA1都可以,不一定要用7-zip;但驗證是必要的,尤其是在非官方網站或知名度、信賴度較低)
SHA-1比對吻合,就可以安心的使用了...
SQLite-tools不需要安裝,解壓縮即可使用 ... SQLite提供文字界面的操作方式,開啟sqlite3.exe後,可以使用 .help 查看相關管指令
Help 指令清單
.archive ... | Manage SQL archives |
.auth ON|OFF | Show authorizer callbacks |
.backup ?DB? FILE | Backup DB (default "main") to FILE |
.bail on|off | Stop after hitting an error. Default OFF |
.binary on|off | Turn binary output on or off. Default OFF |
.cd DIRECTORY | Change the working directory to DIRECTORY |
.changes on|off | Show number of rows changed by SQL |
.check GLOB | Fail if output since .testcase does not match |
.clone NEWDB | Clone data into NEWDB from the existing database |
.databases | List names and files of attached databases |
.dbconfig ?op? ?val? | List or change sqlite3_db_config() options |
.dbinfo ?DB? | Show status information about the database |
.dump ?TABLE? ... | Render all database content as SQL |
.echo on|off | Turn command echo on or off |
.eqp on|off|full|... | Enable or disable automatic EXPLAIN QUERY PLAN |
.excel | Display the output of next command in a spreadsheet |
.exit ?CODE? | Exit this program with return-code CODE |
.expert | EXPERIMENTAL. Suggest indexes for specified queries |
.filectrl CMD ... | Run various sqlite3_file_control() operations |
.fullschema ?--indent? | Show schema and the content of sqlite_stat tables |
.headers on|off | Turn display of headers on or off |
.help ?-all? ?PATTERN? | Show help text for PATTERN |
.import FILE TABLE | Import data from FILE into TABLE |
.imposter INDEX TABLE | Create imposter table TABLE on index INDEX |
.indexes ?TABLE? | Show names of indexes |
.limit ?LIMIT? ?VAL? | Display or change the value of an SQLITE_LIMIT |
.lint OPTIONS | Report potential schema issues. |
.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 |
.nullvalue STRING | Use STRING in place of NULL values |
.once (-e|-x|FILE) | Output for the next SQL command only to FILE |
.open ?OPTIONS? ?FILE? | Close existing database and reopen FILE |
.output ?FILE? | Send output to FILE or stdout if FILE is omitted |
.parameter CMD ... | Manage SQL parameter bindings |
.print STRING... | Print literal STRING |
.progress N | Invoke progress handler after every N opcodes |
.prompt MAIN CONTINUE | Replace the standard prompts |
.quit | Exit this program |
.read FILE | Read input from FILE |
.recover | Recover as much data as possible from corrupt db. |
.restore ?DB? FILE | Restore content of DB (default "main") from FILE |
.save FILE | Write in-memory database into FILE |
.scanstats on|off | Turn sqlite3_stmt_scanstatus() metrics on or off |
.schema ?PATTERN? | Show the CREATE statements matching PATTERN |
.selftest ?OPTIONS? | Run tests defined in the SELFTEST table |
.separator COL ?ROW? | Change the column and row separators |
.sha3sum ... | Compute a SHA3 hash of database content |
.shell CMD ARGS... | Run CMD ARGS... in a system shell |
.show | Show the current values for various settings |
.stats ?on|off? | Show stats or turn stats on or off |
.system CMD ARGS... | Run CMD ARGS... in a system shell |
.tables ?TABLE? | List names of tables matching LIKE pattern TABLE |
.testcase NAME | Begin redirecting output to 'testcase-out.txt' |
.testctrl CMD ... | Run various sqlite3_test_control() operations |
.timeout MS | Try opening locked tables for MS milliseconds |
.timer on|off | Turn SQL timer on or off |
.trace ?OPTIONS? | Output each SQL statement as it is run |
.vfsinfo ?AUX? | Information about the top-level VFS |
.vfslist | List all available VFSes |
.vfsname ?AUX? | Print the name of the VFS stack |
.width NUM1 NUM2 ... | Set column widths for "column" mode |