sqlite 10 sec guide


You want to get up and running with sqlite



Install sqlite3 on linux, via yum: yum install sqlite3

Then just run sqlite dbname



% 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



  1. sqlite3 linux man page
  2. sqlite official site