learning sqlite

# create table named t3 (id, value). id is integer. value is text
sqlite> create table if not exists t3( id int , value varchar, primary key(id));

# adding two "rows"
sqlite> insert into t3 (id, value) values (1, 'a');
sqlite> insert into t3 (id, value) values (2, 'b');

# display results
sqlite> select *  from t3;
1|a
2|b

# update id=1 if exists, insert otherwise (id=1 exists)
sqlite> insert or replace into t3 (id,value) values (1,'c' );
sqlite> select *  from t3;
2|b
1|c

# update id=1 if exists, insert otherwise (id=1 doesn't exist)
sqlite> insert or replace into t3 (id,value) values (3,'e' );
sqlite> select *  from t3;
2|b
1|c
3|e

# update id=1 if exists, insert otherwise (id=1 doesn't exist)
sqlite> insert or replace into t3 (id,value) values (3,'f' );
sqlite> select *  from t3;
2|b
1|c
3|f