sqlite3 <FILENAME>
A command line interface for SQLite version 3
Arguments
Options
Name | Description |
---|
-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 |
-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 |
-header | Turn headers on |
-noheader | Turn headers off |
-help | Show help message |
-html | Set output mode to HTML |
-interactive | Force interactive I/O |
-line | Set output mode to 'line' |
-list | Set output mode to 'list' |
-lookaside <SIZE> <N> | Use N entries of SZ bytes for lookaside memory |
-memtrace | Trace all memory allocations and deallocations |
-mmap <N> | Default mmap size set to N |
-newline <SEP> | Set output row separator |
-nofollow | Refuse to open symbolic links to database files |
-nullvalue <TEXT> | Set text string for NULL values |
-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 |
-stats | Print memory stats before each finalize |
-version | Show SQLite version |
-vfs <NAME> | Use NAME as the default VFS |