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...