sqlite3 <FILENAME>

A command line interface for SQLite version 3

Arguments

NameDescription
FILENAME

Options

NameDescription
-appendAppend the database to the end of the file
-asciiSet output mode to 'ascii'
-bailStop after hitting an error
-batchForce batch I/O
-columnSet output mode to 'column'
-cmd <COMMAND>Run "COMMAND" before reading stdin
-csvSet output mode to 'csv'
-echoPrint commands before execution
-init <FILENAME>Read/process named file
-headerTurn headers on
-noheaderTurn headers off
-helpShow help message
-htmlSet output mode to HTML
-interactiveForce interactive I/O
-lineSet output mode to 'line'
-listSet output mode to 'list'
-lookaside <SIZE> <N>Use N entries of SZ bytes for lookaside memory
-memtraceTrace all memory allocations and deallocations
-mmap <N>Default mmap size set to N
-newline <SEP>Set output row separator
-nofollowRefuse 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
-quoteSet output mode to 'quote'
-readonlyOpen the database read-only
-separator <SEP>Set output column separator
-statsPrint memory stats before each finalize
-versionShow SQLite version
-vfs <NAME>Use NAME as the default VFS