Lines Matching refs:t1
30 CREATE TABLE t1(x);
31 INSERT INTO t1 VALUES(1);
32 INSERT INTO t1 SELECT x+1 FROM t1;
33 INSERT INTO t1 SELECT x+2 FROM t1;
34 INSERT INTO t1 SELECT x+4 FROM t1;
35 SELECT * FROM t1;
72 SELECT * FROM t1;
86 SELECT * FROM t1;
99 CREATE INDEX i1 ON t1(x);
100 DELETE FROM t1;
103 INSERT INTO cnt VALUES('t1',0,0);
105 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
106 UPDATE cnt SET ins=ins+1 WHERE name='t1';
108 CREATE TRIGGER r2 AFTER DELETE ON t1 FOR EACH ROW BEGIN
109 UPDATE cnt SET del=del+1 WHERE name='t1';
117 CREATE VIEW v1 AS SELECT x+100 FROM t1;
119 INSERT INTO t1 VALUES(1);
120 INSERT INTO t1 SELECT x+1 FROM t1;
121 INSERT INTO t1 SELECT x+2 FROM t1;
122 INSERT INTO t1 SELECT x+4 FROM t1;
123 SELECT * FROM t1;
135 } {t1 8 0 t2 0 0}
138 INSERT INTO t2 SELECT x*3, x*2, x FROM t1;
146 } {t1 8 0 t2 8 0}
160 } {t1 8 0 t2 8 0}