Lines Matching refs:INSERT

15 # focus of this file is testing the INSERT statement that takes is
29     execsql "INSERT INTO d1 VALUES($i,$j)"
40     INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
54     INSERT INTO t1 
69     INSERT INTO t1 
85     INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
96     INSERT INTO t4 VALUES(1,2);
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;
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);
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;
174     INSERT INTO t4 SELECT x+(SELECT max(x)+1 FROM t4),y FROM t4;