Lines Matching refs:INSERT
36 # cmd An INSERT or REPLACE command to execute against table t1
42 1 {} INSERT 1 {} 1
43 2 {} {INSERT OR IGNORE} 0 3 1
44 3 {} {INSERT OR REPLACE} 0 4 1
46 5 {} {INSERT OR FAIL} 1 {} 1
47 6 {} {INSERT OR ABORT} 1 {} 1
48 7 {} {INSERT OR ROLLBACK} 1 {} {}
49 8 IGNORE INSERT 0 3 1
50 9 IGNORE {INSERT OR IGNORE} 0 3 1
51 10 IGNORE {INSERT OR REPLACE} 0 4 1
53 12 IGNORE {INSERT OR FAIL} 1 {} 1
54 13 IGNORE {INSERT OR ABORT} 1 {} 1
55 14 IGNORE {INSERT OR ROLLBACK} 1 {} {}
56 15 REPLACE INSERT 0 4 1
57 16 FAIL INSERT 1 {} 1
58 17 ABORT INSERT 1 {} 1
59 18 ROLLBACK INSERT 1 {} {}
66 INSERT INTO t1 VALUES(1,2,3);
68 INSERT INTO t2 VALUES(1);
94 # cmd An INSERT or REPLACE command to execute against table t1
100 1 {} INSERT 1 {} 1
101 2 {} {INSERT OR IGNORE} 0 3 1
102 3 {} {INSERT OR REPLACE} 0 4 1
104 5 {} {INSERT OR FAIL} 1 {} 1
105 6 {} {INSERT OR ABORT} 1 {} 1
106 7 {} {INSERT OR ROLLBACK} 1 {} {}
107 8 IGNORE INSERT 0 3 1
108 9 IGNORE {INSERT OR IGNORE} 0 3 1
109 10 IGNORE {INSERT OR REPLACE} 0 4 1
111 12 IGNORE {INSERT OR FAIL} 1 {} 1
112 13 IGNORE {INSERT OR ABORT} 1 {} 1
113 14 IGNORE {INSERT OR ROLLBACK} 1 {} {}
114 15 REPLACE INSERT 0 4 1
115 16 FAIL INSERT 1 {} 1
116 17 ABORT INSERT 1 {} 1
117 18 ROLLBACK INSERT 1 {} {}
124 INSERT INTO t1 VALUES(1,2,3);
126 INSERT INTO t2 VALUES(1);
152 # cmd An INSERT or REPLACE command to execute against table t1
158 1 {} INSERT 1 {} 1
159 2 {} {INSERT OR IGNORE} 0 3 1
160 3 {} {INSERT OR REPLACE} 0 4 1
162 5 {} {INSERT OR FAIL} 1 {} 1
163 6 {} {INSERT OR ABORT} 1 {} 1
164 7 {} {INSERT OR ROLLBACK} 1 {} {}
165 8 IGNORE INSERT 0 3 1
166 9 IGNORE {INSERT OR IGNORE} 0 3 1
167 10 IGNORE {INSERT OR REPLACE} 0 4 1
169 12 IGNORE {INSERT OR FAIL} 1 {} 1
170 13 IGNORE {INSERT OR ABORT} 1 {} 1
171 14 IGNORE {INSERT OR ROLLBACK} 1 {} {}
172 15 REPLACE INSERT 0 4 1
173 16 FAIL INSERT 1 {} 1
174 17 ABORT INSERT 1 {} 1
175 18 ROLLBACK INSERT 1 {} {}
182 INSERT INTO t1 VALUES(1,2,3);
184 INSERT INTO t2 VALUES(1);
207 # cmd An INSERT or REPLACE command to execute against table t1
213 1 {} {} INSERT 1 {} 1
214 2 REPLACE {} INSERT 0 4 1
215 3 IGNORE {} INSERT 0 3 1
216 4 FAIL {} INSERT 1 {} 1
217 5 ABORT {} INSERT 1 {} 1
218 6 ROLLBACK {} INSERT 1 {} {}
219 7 REPLACE {} {INSERT OR IGNORE} 0 3 1
220 8 IGNORE {} {INSERT OR REPLACE} 0 4 1
221 9 FAIL {} {INSERT OR IGNORE} 0 3 1
222 10 ABORT {} {INSERT OR REPLACE} 0 4 1
223 11 ROLLBACK {} {INSERT OR IGNORE } 0 3 1
224 12 REPLACE IGNORE INSERT 0 3 1
225 13 IGNORE REPLACE INSERT 0 4 1
226 14 FAIL IGNORE INSERT 0 3 1
227 15 ABORT REPLACE INSERT 0 4 1
228 16 ROLLBACK IGNORE INSERT 0 3 1
229 12 IGNORE REPLACE INSERT 0 4 1
230 13 IGNORE FAIL INSERT 1 {} 1
231 14 IGNORE ABORT INSERT 1 {} 1
232 15 IGNORE ROLLBACK INSERT 1 {} {}
241 INSERT INTO t1 VALUES(1,2,3);
243 INSERT INTO t2 VALUES(1);
266 # cmd An INSERT or REPLACE command to execute against table t1
272 1 {} {} INSERT 1 {} 1
273 2 REPLACE {} INSERT 0 5 1
274 3 IGNORE {} INSERT 0 {} 1
275 4 FAIL {} INSERT 1 {} 1
276 5 ABORT {} INSERT 1 {} 1
277 6 ROLLBACK {} INSERT 1 {} {}
278 7 REPLACE {} {INSERT OR IGNORE} 0 {} 1
279 8 IGNORE {} {INSERT OR REPLACE} 0 5 1
280 9 FAIL {} {INSERT OR IGNORE} 0 {} 1
281 10 ABORT {} {INSERT OR REPLACE} 0 5 1
282 11 ROLLBACK {} {INSERT OR IGNORE} 0 {} 1
283 12 {} {} {INSERT OR IGNORE} 0 {} 1
284 13 {} {} {INSERT OR REPLACE} 0 5 1
285 14 {} {} {INSERT OR FAIL} 1 {} 1
286 15 {} {} {INSERT OR ABORT} 1 {} 1
287 16 {} {} {INSERT OR ROLLBACK} 1 {} {}
288 17 {} IGNORE INSERT 0 {} 1
289 18 {} REPLACE INSERT 0 5 1
290 19 {} FAIL INSERT 1 {} 1
291 20 {} ABORT INSERT 1 {} 1
292 21 {} ROLLBACK INSERT 1 {} {}
293 22 REPLACE FAIL INSERT 1 {} 1
294 23 IGNORE ROLLBACK INSERT 1 {} {}
305 INSERT INTO t2 VALUES(1);
319 INSERT INTO t2 VALUES(1,2,1);
320 INSERT INTO t2 VALUES(2,3,2);
321 INSERT INTO t2 VALUES(3,4,1);
322 INSERT INTO t2 VALUES(4,5,4);
325 INSERT INTO t3 VALUES(1);
374 INSERT INTO t1 SELECT * FROM t2;
398 execsql "INSERT into t1 values($i,[expr {$i+1}]);"
452 INSERT INTO t1 VALUES(1,2);
455 INSERT OR IGNORE INTO t1 VALUES(2,3);
463 INSERT OR IGNORE INTO t1 VALUES(2,4);
471 INSERT OR REPLACE INTO t1 VALUES(2,4);
479 INSERT OR IGNORE INTO t1 SELECT * FROM t1;
487 INSERT OR IGNORE INTO t1 SELECT a+2,b+2 FROM t1;
495 INSERT OR IGNORE INTO t1 SELECT a+3,b+3 FROM t1;
515 INSERT INTO t3 VALUES(1);
521 INSERT INTO t2 VALUES(1,1,1,1,1);
522 INSERT INTO t2 VALUES(2,2,2,2,2);
528 INSERT INTO t2 VALUES(1,3,3,3,3);
540 INSERT INTO t2 VALUES(3,1,3,3,3);
554 INSERT INTO t2 VALUES(3,1,3,3,3);
576 INSERT INTO t2 VALUES(3,3,3,1,3);
590 INSERT INTO t2 VALUES(3,3,3,1,3);
612 INSERT INTO t2 VALUES(3,3,3,3,1);
626 INSERT INTO t2 VALUES(3,3,3,3,1);
648 INSERT INTO t2 VALUES(3,3,1,3,3);
662 INSERT INTO t2 VALUES(3,3,1,3,3);
675 INSERT INTO t1 VALUES(1,2);
676 INSERT INTO t1 VALUES(1,3);
686 INSERT INTO t4 VALUES(1);
687 INSERT INTO t4 VALUES(1);