Lines Matching refs:t3
207 CREATE TABLE t3(a);
208 INSERT INTO t3 VALUES(1);
209 INSERT INTO t3 SELECT a+1 FROM t3;
210 INSERT INTO t3 SELECT a+2 FROM t3;
211 SELECT * FROM t3;
218 CREATE TRIGGER r1 AFTER DELETE ON t3 FOR EACH ROW BEGIN
221 DELETE FROM t3 WHERE a<2;
222 SELECT * FROM t3;
232 DELETE FROM t3;
233 SELECT * FROM t3;
243 INSERT INTO t3 VALUES(1);
244 INSERT INTO t3 SELECT a+1 FROM t3;
245 INSERT INTO t3 SELECT a+2 FROM t3;
246 CREATE TABLE t4 AS SELECT * FROM t3;
248 DELETE FROM t3;
260 INSERT INTO t3 VALUES(123);
261 SELECT * FROM t3;
270 DELETE FROM t3;
274 execsql {SELECT * FROM t3}
278 DELETE FROM t3 WHERE 1;
282 execsql {SELECT * FROM t3}
286 DELETE FROM t3 WHERE a<100;
290 execsql {SELECT * FROM t3}