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 couple of records into that table: SQLite version
3.1.3 Enter ".help" for instructions sqlite> create table
memos(text, priority INTEGER); sqlite> insert into memos
values(’deliver project description’, 10); sqlite> insert into
memos values(’lunch with Christine’, 100); sqlite> select * from
memos; deliver project description|10 lunch with Chr