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 |
