Lines Matching refs:FROM

31   execsql {SELECT * FROM d1 ORDER BY n}
40     INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
47   execsql {SELECT * FROM t1 ORDER BY log}
55        SELECT log, count(*) FROM d1 GROUP BY log
56        EXCEPT SELECT n-1,log FROM d1;
61     SELECT * FROM t1 ORDER BY log;
70        SELECT log, count(*) FROM d1 GROUP BY log
71        INTERSECT SELECT n-1,log FROM d1;
76     SELECT * FROM t1 ORDER BY log;
85     INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
86     SELECT * FROM t1 ORDER BY log;
88   lappend r [execsql {SELECT cnt FROM t1 WHERE log=3}]
89   lappend r [execsql {SELECT log FROM t1 WHERE cnt=4 ORDER BY log}]
97     SELECT * FROM t4;
102     INSERT INTO t3(a,c) SELECT * FROM t4;
103     SELECT * FROM t3;
108     DELETE FROM t3;
109     INSERT INTO t3(c,b) SELECT * FROM t4;
110     SELECT * FROM t3;
115     DELETE FROM t3;
116     INSERT INTO t3(c,a,b) SELECT x, 'hi', y FROM t4;
117     SELECT * FROM t3;
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;
168     SELECT count(*) FROM t4;
174     INSERT INTO t4 SELECT x+(SELECT max(x)+1 FROM t4),y FROM t4;
181     SELECT count(*) FROM t4;
187     DELETE FROM t4 WHERE x!=123;
188     SELECT count(*) FROM t4;