sqlite 10 sec guide

Problem

You want to get up and running with sqlite



Solution

Install sqlite3 on linux, via yum: yum install sqlite3

Then just run sqlite dbname



Example



% sqlite3 testdata.db
SQLite version 3.5.9
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 Christine|100
sqlite>