SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.
.tables .schema tablename
UPDATE users SET role=99 WHERE name='Fred'
To execute a query on the command line:
sqlite3 blah.db "select * from table" > file.out
- About SQLite http://www.sqlite.org/about.html