Mac Developer Library Developer   This manual page is for
Mac OS X version 10.9     • In Terminal, using the man(1)
command  Reading manual pages      SQLITE3(1)
SQLITE3(1)         sqlite3 - A command line interface for SQLite
version 3         sqlite3 [options] [databasefile] [SQL]
sqlite3  is  a terminal-based front-end to the SQLite library
that can evaluate queries interactively        and display the
results in multiple formats.  sqlite3 can also be used within
shell scripts and other        applications to provide batch
processing features.         To start a sqlite3 interactive
session, invoke the sqlite3 command and optionally provide the
name of        a database file.  If the database file does not
exist, it will be created.  If the database file does
exist, it will be opened.         For example, to create a new
database file named "mydata.db", create a table named "memos"
and insert        a coupl