sqlite

NAME

SYNOPSIS

sqlite3 [ -init filename ] [ -echo ] [ -[no]header ] [ -bail ] [ -interactive ] [ -batch ] [ -column ] [ -csv ] [ -html ] [ -line ] [ -list ] [ -separator aqxaq ] [ -nullvalue aqtextaq ] [ FILENAME [ SQL ] ]

AVAILABILITY

DESCRIPTION

SQLite is the most widely deployed SQL database engine in the world. It is used in countless desktop computer applications as well as consumer electronic devices including cellphones, PDAs, and MP3 players. The source code for SQLite is in the public domain.

The SQLite library includes a simple command-line utility named sqlite3 that allows the user to manually enter and execute SQL commands against an SQLite database.

This man page provides a brief introduction to the options of sqlite3 and provides the link to the HTML documentation.

OPTIONS

-help

usage message.

-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

set output mode to aqcolumnaq .

-csv

set output mode to aqcsvaq .

-html

set output mode to aqHTMLaq .

-init filename

read/process commands from the filename .

-line

set output mode to aqlineaq .

-list

set output mode to aqlistaq .

-separator aqxaq

set output field separator (|).

-nullvalue aqtextaq

set text string for NULL values.

-version

show SQLite version.

FILENAME

database file name.

SQL

SQL statements.

ENVIRONMENT

EXIT STATUS

FILES

var/db/sqlite/

directory for SQLite databases.

EXAMPLES

SEE ALSO

NOTES

BUGS

AUTHOR

COPYRIGHT

This is free software; see edrc/doc/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.