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

Leave a Reply

Your email address will not be published. Required fields are marked *