Lines Matching refs:INSERT
13 # focus of this file is testing the INSERT statement that takes is
27 execsql "INSERT INTO d1 VALUES($i,$j)"
38 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
52 INSERT INTO t1
67 INSERT INTO t1
83 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
94 INSERT INTO t4 VALUES(1,2);
100 INSERT INTO t3(a,c) SELECT * FROM t4;
107 INSERT INTO t3(c,b) SELECT * FROM t4;
114 INSERT INTO t3(c,a,b) SELECT x, 'hi', y FROM t4;
131 INSERT INTO t4 VALUES(2,4);
132 INSERT INTO t4 VALUES(3,6);
133 INSERT INTO t4 VALUES(4,8);
134 INSERT INTO t4 VALUES(5,10);
135 INSERT INTO t4 VALUES(6,12);
136 INSERT INTO t4 VALUES(7,14);
137 INSERT INTO t4 VALUES(8,16);
138 INSERT INTO t4 VALUES(9,18);
139 INSERT INTO t4 VALUES(10,20);
152 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y FROM t4;
153 INSERT INTO t4 SELECT x+(SELECT max(x) FROM t4),y 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;
172 INSERT INTO t4 SELECT x+(SELECT max(x)+1 FROM t4),y FROM t4;