-init file | Read and execute commands from file , which can contain a mix of SQL statements and meta-commands. |
-echo | Print commands before execution. |
-[no]header | Turn headers on or off. |
-bail | Stop after hitting an error. |
-interactive | Force interactive I/O . |
-batch | Force batch I/O . |
-column | Query results will be displayed in a table like form, using whitespace characters to separate the columns and align the output. |
-csv | Set output mode to CSV (comma separated values). |
-html | Query results will be output as simple HTML tables. |
-line | Query results will be displayed with one value per line, rows separated by a blank line. Designed to be easily parsed by scripts or other programs |
-list | Query results will be displayed with the separator (|, by default) character between each field value. The default. |
-separator separator | Set output field separator. Default is “|”. |
-stats | Print memory stats before each finalize. |
-nullvalue string | Set string used to represent NULL values. Default is (empty string). |
-version | Show SQLite version. |
-vfs name | Use name as the default VFS . |
-help | Show help on options and exit. |