Lines Matching refs:t1
45 CREATE TABLE t1(
49 CREATE INDEX i1 ON t1(a,b);
50 INSERT INTO t1 VALUES(1,2.3,4.5,'hi','there');
51 INSERT INTO t1 VALUES(6,7.0,0.8,'hello','out yonder');
52 SELECT * FROM t1;
53 SELECT avg(b) FROM t1 GROUP BY a HAVING b>20.0;
54 DELETE FROM t1 WHERE a IN (SELECT min(a) FROM t1);
55 SELECT count(*) FROM t1;
89 CREATE TABLE t1(a int, b int, c int);
90 CREATE INDEX i1 ON t1(a,b);
91 COPY t1 FROM 'data.tmp';
92 SELECT 'stuff', count(*) as 'other stuff', max(a+10) FROM t1;
93 UPDATE t1 SET b=b||b||b||b;
94 UPDATE t1 SET b=a WHERE a in (10,12,22);
95 INSERT INTO t1(c,b,a) VALUES(20,10,5);
96 INSERT INTO t1 SELECT * FROM t1
97 WHERE a IN (SELECT a FROM t1 WHERE a<10);
98 DELETE FROM t1 WHERE a>=10;
100 DELETE FROM t1;
135 CREATE TABLE t1(a int, b int, c int);
136 CREATE INDEX i1 ON t1(a,b);
137 COPY t1 FROM 'data.tmp';
138 INSERT INTO t1(c,b,a) VALUES(20,10,5);
139 DELETE FROM t1 WHERE a>=10;
141 DELETE FROM t1;
170 CREATE TABLE t1(a int, b int, c int);
171 CREATE INDEX i1 ON t1(a,b);
172 COPY t1 FROM 'data.tmp';
173 UPDATE t1 SET b=a WHERE a in (10,12,22);
174 INSERT INTO t1 SELECT * FROM t1
175 WHERE a IN (SELECT a FROM t1 WHERE a<10);
177 DELETE FROM t1;
206 CREATE TABLE t1(a,b);
208 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
211 INSERT INTO t1(a,b) VALUES(2,3);