Command Line

Links

• http://www.sqlite.org/sqlite.html sqlite3: A command-line access program for SQLite databases.

Install

sudo apt-get install sqlite3

Getting Started

sqlite3 my.db
sqlite> .tables
sqlite> SELECT * FROM monitor;
sqlite> .quit

SELECT

Set the mode so we can see the data in columns:

sqlite> .headers on
sqlite> .mode column
sqlite> SELECT * FROM monitor;

Schema

sqlite3 ~/repo/sqlite/demo.db
sqlite> .tables
sqlite> .schema client_info