Linux command
sqlitebrowser 命令
文本
复制后可按需替换文件名、目录或参数。
常用示例
Open a database file
sqlitebrowser [database.db]
Open a database in read-only mode
sqlitebrowser -R [database.db]
Execute a SQL file after opening
sqlitebrowser -s [script.sql] [database.db]
Import a CSV file
sqlitebrowser --import-csv [data.csv] [database.db]
Open to a specific table
sqlitebrowser -t [tablename] [database.db]
说明
sqlitebrowser (DB Browser for SQLite) is a visual, open-source tool for creating, designing, and editing SQLite database files. It provides a spreadsheet-like interface for browsing data, an SQL editor for running queries, and tools for managing tables, indexes, and triggers. Despite being a graphical application, it supports useful command-line options for automation, such as importing CSV files, executing SQL scripts, and opening specific tables.
参数
- -h, --help
- Show command-line options.
- -v, --version
- Display version.
- -q, --quit
- Exit after executing scripts.
- -s _FILE_, --sql _FILE_
- Execute SQL file after opening database.
- --import-csv _FILE_
- Import CSV file into database.
- -t _TABLE_, --table _TABLE_
- Browse a specific table on startup.
- -R, --read-only
- Open database in read-only mode.
- -S _FILE_, --settings _FILE_
- Use specified settings file.
- -o _SETTING_, --option _SETTING_
- Temporarily set a setting (group/setting=value).
- --in-memory
- Start with an in-memory database.
FAQ
What is the sqlitebrowser command used for?
sqlitebrowser (DB Browser for SQLite) is a visual, open-source tool for creating, designing, and editing SQLite database files. It provides a spreadsheet-like interface for browsing data, an SQL editor for running queries, and tools for managing tables, indexes, and triggers. Despite being a graphical application, it supports useful command-line options for automation, such as importing CSV files, executing SQL scripts, and opening specific tables.
How do I run a basic sqlitebrowser example?
Run `sqlitebrowser [database.db]` in a terminal, then adjust file names, paths, flags, or remote targets for your system.
What does -h, --help do in sqlitebrowser?
Show command-line options.