Lines Matching refs:INSERT

36     INSERT INTO t3 VALUES(randstr(10,400));
37     INSERT INTO t3 VALUES(randstr(10,400));
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;
89        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
90        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
101        INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
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;
128     INSERT INTO t4 VALUES(1,2,3,4);
164 #   cmd    An INSERT or REPLACE command to execute against table t1
170   1 {}       INSERT                  1 {}  1
171   2 {}       {INSERT OR IGNORE}      0 3   1
172   3 {}       {INSERT OR REPLACE}     0 4   1
174   5 {}       {INSERT OR FAIL}        1 {}  1
175   6 {}       {INSERT OR ABORT}       1 {}  1
176   7 {}       {INSERT OR ROLLBACK}    1 {}  {}
177   8 IGNORE   INSERT                  0 3   1
178   9 IGNORE   {INSERT OR IGNORE}      0 3   1
179  10 IGNORE   {INSERT OR REPLACE}     0 4   1
181  12 IGNORE   {INSERT OR FAIL}        1 {}  1
182  13 IGNORE   {INSERT OR ABORT}       1 {}  1
183  14 IGNORE   {INSERT OR ROLLBACK}    1 {}  {}
184  15 REPLACE  INSERT                  0 4   1
185  16 FAIL     INSERT                  1 {}  1
186  17 ABORT    INSERT                  1 {}  1
187  18 ROLLBACK INSERT                  1 {}  {}
194       INSERT INTO t1 VALUES(1,2,3);
196       INSERT INTO t2 VALUES(1); 
211     INSERT INTO t2 VALUES(1,2,1);
212     INSERT INTO t2 VALUES(2,3,2);
213     INSERT INTO t2 VALUES(3,4,1);
214     INSERT INTO t2 VALUES(4,5,4);
217     INSERT INTO t3 VALUES(1);
266       INSERT INTO t1 SELECT * FROM t2;
323     INSERT INTO t5 VALUES(1,2);
351     INSERT INTO t5 VALUES(1,2);
352     INSERT INTO t5 VALUES(3,4);
379     INSERT INTO t6 VALUES(1);
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;