Lines Matching refs:INSERT
34 INSERT INTO t3 VALUES(randstr(10,400));
35 INSERT INTO t3 VALUES(randstr(10,400));
36 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
37 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
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;
87 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
88 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
99 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
101 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
109 INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE random()%10==0;
126 INSERT INTO t4 VALUES(1,2,3,4);
162 # cmd An INSERT or REPLACE command to execute against table t1
168 1 {} INSERT 1 {} 1
169 2 {} {INSERT OR IGNORE} 0 3 1
170 3 {} {INSERT OR REPLACE} 0 4 1
172 5 {} {INSERT OR FAIL} 1 {} 1
173 6 {} {INSERT OR ABORT} 1 {} 1
174 7 {} {INSERT OR ROLLBACK} 1 {} {}
175 8 IGNORE INSERT 0 3 1
176 9 IGNORE {INSERT OR IGNORE} 0 3 1
177 10 IGNORE {INSERT OR REPLACE} 0 4 1
179 12 IGNORE {INSERT OR FAIL} 1 {} 1
180 13 IGNORE {INSERT OR ABORT} 1 {} 1
181 14 IGNORE {INSERT OR ROLLBACK} 1 {} {}
182 15 REPLACE INSERT 0 4 1
183 16 FAIL INSERT 1 {} 1
184 17 ABORT INSERT 1 {} 1
185 18 ROLLBACK INSERT 1 {} {}
192 INSERT INTO t1 VALUES(1,2,3);
194 INSERT INTO t2 VALUES(1);
209 INSERT INTO t2 VALUES(1,2,1);
210 INSERT INTO t2 VALUES(2,3,2);
211 INSERT INTO t2 VALUES(3,4,1);
212 INSERT INTO t2 VALUES(4,5,4);
215 INSERT INTO t3 VALUES(1);
264 INSERT INTO t1 SELECT * FROM t2;
321 INSERT INTO t5 VALUES(1,2);
349 INSERT INTO t5 VALUES(1,2);
350 INSERT INTO t5 VALUES(3,4);
377 INSERT INTO t6 VALUES(1);
378 INSERT INTO t6 SELECT x+1 FROM t6;
379 INSERT INTO t6 SELECT x+2 FROM t6;
380 INSERT INTO t6 SELECT x+4 FROM t6;
381 INSERT INTO t6 SELECT x+8 FROM t6;
382 INSERT INTO t6 SELECT x+16 FROM t6;
383 INSERT INTO t6 SELECT x+32 FROM t6;
384 INSERT INTO t6 SELECT x+64 FROM t6;
385 INSERT INTO t6 SELECT x+128 FROM t6;