Lines Matching refs:q

43     CREATE TABLE q(s string, id string, constraint pk_q primary key(id));
45     INSERT INTO q(s,id) VALUES('hello','id.1');
46     INSERT INTO q(s,id) VALUES('goodbye','id.2');
47     INSERT INTO q(s,id) VALUES('again','id.3');
49     SELECT * FROM q;
54     SELECT * FROM q WHERE id='id.1';
63   set STMT [sqlite3_prepare $DB {SELECT * FROM q} -1 TAIL]
73     DELETE FROM q WHERE rowid=1
79     SELECT * FROM q;
89     DELETE FROM q WHERE rowid=1
95     SELECT * FROM q;