$ sqlite3 foo.db
SQLite version 3.2.8
Enter ".help" for instructions
sqlite> create table players (id integer, name varchar(256), score integer);
sqlite> insert into players (id, name, score) values (1, "bob", 100);
sqlite> insert into players (id, name, score) values (2, "sally", 200);
sqlite> insert into players (id, name, score) values (3, "frank", 10);
sqlite> select * from players;
1|bob|100
2|sally|200
3|frank|10
sqlite> select score from players where name='sally';
200
sqlite> update players set score=score+10 where name='sally';
sqlite> select score from players where name='sally';
210
sqlite> delete from players where name='bob';
sqlite> select * from players;
2|sally|210
3|frank|10
sqlite>