Lines Matching refs:b1

88     CREATE TABLE b1(a INTEGER PRIMARY KEY, b, c);
92     CREATE TABLE b1(a INT PRIMARY KEY, b, c) WITHOUT ROWID;
96   execsql { DROP TABLE IF EXISTS b1; DROP TABLE IF EXISTS c1; }
100     CREATE UNIQUE INDEX b1c ON b1(c);
101     INSERT INTO b1 VALUES(1, 'a', 1);
102     INSERT INTO b1 VALUES(2, 'b', 15);
103     INSERT INTO b1 VALUES(3, 'c', 3);
104     INSERT INTO b1 VALUES(4, 'd', 4);
105     INSERT INTO b1 VALUES(5, 'e', 5);
106     INSERT INTO b1 VALUES(6, 'f', 6);
107     INSERT INTO b1 VALUES(7, 'g', 7);
111     UPDATE OR REPLACE b1 SET c=c+10 WHERE a BETWEEN 4 AND 7;
112     SELECT * FROM b1 ORDER BY a;