Lines Matching refs:t4
95 CREATE TABLE t4(x,y);
96 INSERT INTO t4 VALUES(1,2);
97 SELECT * FROM t4;
102 INSERT INTO t3(a,c) SELECT * FROM t4;
109 INSERT INTO t3(c,b) SELECT * FROM t4;
116 INSERT INTO t3(c,a,b) SELECT x, 'hi', y FROM t4;
123 # File table t4 with lots of data
127 SELECT * from t4;
133 INSERT INTO t4 VALUES(2,4);
134 INSERT INTO t4 VALUES(3,6);
135 INSERT INTO t4 VALUES(4,8);
136 INSERT INTO t4 VALUES(5,10);
137 INSERT INTO t4 VALUES(6,12);
138 INSERT INTO t4 VALUES(7,14);
139 INSERT INTO t4 VALUES(8,16);
140 INSERT INTO t4 VALUES(9,18);
141 INSERT INTO t4 VALUES(10,20);
148 SELECT count(*) FROM t4;
154 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
155 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
156 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
157 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
159 SELECT count(*) FROM t4;
165 UPDATE t4 SET y='lots of data for the row where x=' || x
168 SELECT count(*) FROM t4;
174 INSERT INTO t4 SELECT x+(SELECT max(x)+1 FROM t4),y FROM t4;
175 SELECT count(*) from t4;
181 SELECT count(*) FROM t4;
187 DELETE FROM t4 WHERE x!=123;
188 SELECT count(*) FROM t4;