Lines Matching refs:FROM

38     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
39     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
40     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
41     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
42     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
43     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
44     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
45     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
46     INSERT INTO t3 SELECT randstr(10,400) FROM t3;
48     SELECT count(*) FROM t3;
60   set rx [db eval {SELECT x FROM t3}]
67   # set r [db eval {SELECT count(*), md5sum(x) FROM t3}]
88        DELETE FROM t3 WHERE random()%10!=0;
89        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
90        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
100        DELETE FROM t3 WHERE random()%10!=0;
101        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
102        DELETE FROM t3 WHERE random()%10!=0;
103        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
111          INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE random()%10==0;
129     SELECT * FROM t4;
134     SELECT name FROM sqlite_master WHERE type='table';
140     SELECT name FROM sqlite_master WHERE type='table';
146     SELECT name FROM sqlite_master WHERE type='table';
156     SELECT c FROM t1 ORDER BY c;
192       DELETE FROM t1;
193       DELETE FROM t2;
200     if {$r0} {set r1 {}} {set r1 [execsql {SELECT c FROM t1}]}
201     set r2 [execsql {SELECT x FROM t2}]
215     SELECT c FROM t2 ORDER BY b;
266       INSERT INTO t1 SELECT * FROM t2;
274     if {!$r0} {set r1 [execsql {SELECT a FROM t1 ORDER BY b}]}
275     set r2 [execsql {SELECT x FROM t3}]
282     SELECT * FROM t2;
289     SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
295     SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
300     SELECT * FROM t2;
305     SELECT a FROM t2 UNION SELECT b FROM t2 ORDER BY 1;
311     SELECT a FROM t2 ORDER BY c;
316     SELECT a FROM t2 ORDER BY c DESC;
324     SELECT * FROM t5;
329     SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
335     SELECT name FROM sqlite_master WHERE type='table' ORDER BY 1;
341     SELECT * FROM t5;
346     SELECT * FROM t5 ORDER BY y DESC;
354     SELECT rowid,* FROM t5;
359     DELETE FROM t5 WHERE x>5;
360     SELECT * FROM t5;
365     DELETE FROM t5 WHERE y<3;
366     SELECT * FROM t5;
371     DELETE FROM t5 WHERE x>0;
372     SELECT * FROM t5;
380     INSERT INTO t6 SELECT x+1 FROM t6;
381     INSERT INTO t6 SELECT x+2 FROM t6;
382     INSERT INTO t6 SELECT x+4 FROM t6;
383     INSERT INTO t6 SELECT x+8 FROM t6;
384     INSERT INTO t6 SELECT x+16 FROM t6;
385     INSERT INTO t6 SELECT x+32 FROM t6;
386     INSERT INTO t6 SELECT x+64 FROM t6;
387     INSERT INTO t6 SELECT x+128 FROM t6;
388     SELECT count(*) FROM (SELECT DISTINCT x FROM t6);
393      execsql "DELETE FROM t6 WHERE x=\
394               (SELECT x FROM t6 ORDER BY random() LIMIT 1)"
395      execsql {SELECT count(*) FROM t6}