Lines Matching refs:b1
354 CREATE TABLE b1(a INTEGER PRIMARY KEY, b, c UNIQUE);
355 INSERT INTO b1 VALUES(1, '1234567890', 1);
356 INSERT INTO b1 VALUES(2, '1234567890', 2);
357 INSERT INTO b1 VALUES(3, '1234567890', 3);
358 INSERT INTO b1 VALUES(4, '1234567890', 4);
359 INSERT INTO b1 VALUES(5, '1234567890', 5);
360 INSERT INTO b1 VALUES(6, '1234567890', 6);
372 sqlite3_blob_open db main b1 b 2 0 B
377 execsql { DELETE FROM b1 WHERE a = 1 }
381 execsql { DELETE FROM b1 WHERE a = 2 }
389 sqlite3_blob_open db main b1 b 3 0 B
394 execsql { UPDATE b1 SET c = 42 WHERE a=4 }
398 execsql { UPDATE b1 SET c = 43 WHERE a=3 }
406 sqlite3_blob_open db main b1 b 6 0 B
411 execsql { INSERT OR REPLACE INTO b1 VALUES(10, 'abcdefghij', 5) }
415 execsql { INSERT OR REPLACE INTO b1 VALUES(11, 'abcdefghij', 6) }