sqlite3.exe的基本使用

最新推荐文章于 2024-09-08 16:09:36 发布

skyyzq

最新推荐文章于 2024-09-08 16:09:36 发布

阅读量2.9k

点赞数

分类专栏： Python 文章标签： sqlite

本文链接：https://blog.youkuaiyun.com/skyyzq/article/details/113488474

版权

本文介绍了SQLite3.exe的使用，包括显示版本信息、查看帮助文档、打开数据库、执行基本SQL操作等。通过命令行交互，我们可以创建、修改和查询SQLite数据库，如插入数据到表格中，并通过各种命令查看数据库状态。

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

sqlite3.exe Ver 3.33版本 2020-8-14出版，还是蛮新的版本。

E:\sqlite3>sqlite3 --version #显示sqlite3的版本
3.33.0 2020-08-14 13:23:32 fca8dc8b578f215a969cd899336378966156154710873e68b3d9ac5881b0alt2

E:\sqlite3>sqlite3 --help #显示帮助文档
Usage: sqlite3 [OPTIONS] FILENAME [SQL]
FILENAME is the name of an SQLite database. A new database is created
if the file does not previously exist.
OPTIONS include:
-append append the database to the end of the file
-ascii set output mode to 'ascii'
-bail stop after hitting an error
-batch force batch I/O
-box set output mode to 'box'
-column set output mode to 'column'
-cmd COMMAND run "COMMAND" before reading stdin
-csv set output mode to 'csv'
-echo print commands before execution
-init FILENAME read/process named file
-[no]header turn headers on or off
-help show this message
-html set output mode to HTML
-interactive force interactive I/O
-json set output mode to 'json'
-line set output mode to 'line'
-list set output mode to 'list'
-lookaside SIZE N use N entries of SZ bytes for lookaside memory
-markdown set output mode to 'markdown'
-memtrace trace all memory allocations and deallocations
-mmap N default mmap size set to N
-newline SEP set output row separator. Default: '\n'
-nofollow refuse to open symbolic links to database files
-nullvalue TEXT set text string for NULL values. Default ''
-pagecache SIZE N use N slots of SZ bytes each for page cache memory
-quote set output mode to 'quote'
-readonly open the database read-only
-separator SEP set output column separator. Default: '|'
-stats print memory stats before each finalize
-table set output mode to 'table'
-version

最低0.47元/天解锁文章