Lines Matching refs:t3
205 CREATE TABLE t3(a);
206 INSERT INTO t3 VALUES(1);
207 INSERT INTO t3 SELECT a+1 FROM t3;
208 INSERT INTO t3 SELECT a+2 FROM t3;
209 SELECT * FROM t3;
216 CREATE TRIGGER r1 AFTER DELETE ON t3 FOR EACH ROW BEGIN
219 DELETE FROM t3 WHERE a<2;
220 SELECT * FROM t3;
230 DELETE FROM t3;
231 SELECT * FROM t3;
241 INSERT INTO t3 VALUES(1);
242 INSERT INTO t3 SELECT a+1 FROM t3;
243 INSERT INTO t3 SELECT a+2 FROM t3;
244 CREATE TABLE t4 AS SELECT * FROM t3;
246 DELETE FROM t3;
258 INSERT INTO t3 VALUES(123);
259 SELECT * FROM t3;
268 DELETE FROM t3;
272 execsql {SELECT * FROM t3}
276 DELETE FROM t3 WHERE 1;
280 execsql {SELECT * FROM t3}
284 DELETE FROM t3 WHERE a<100;
288 execsql {SELECT * FROM t3}