Lines Matching refs:INSERT
38 # cmd An INSERT or REPLACE command to execute against table t1
44 1 {} INSERT 1 {} 1
45 2 {} {INSERT OR IGNORE} 0 3 1
46 3 {} {INSERT OR REPLACE} 0 4 1
48 5 {} {INSERT OR FAIL} 1 {} 1
49 6 {} {INSERT OR ABORT} 1 {} 1
50 7 {} {INSERT OR ROLLBACK} 1 {} {}
51 8 IGNORE INSERT 0 3 1
52 9 IGNORE {INSERT OR IGNORE} 0 3 1
53 10 IGNORE {INSERT OR REPLACE} 0 4 1
55 12 IGNORE {INSERT OR FAIL} 1 {} 1
56 13 IGNORE {INSERT OR ABORT} 1 {} 1
57 14 IGNORE {INSERT OR ROLLBACK} 1 {} {}
58 15 REPLACE INSERT 0 4 1
59 16 FAIL INSERT 1 {} 1
60 17 ABORT INSERT 1 {} 1
61 18 ROLLBACK INSERT 1 {} {}
68 INSERT INTO t1 VALUES(1,2,3);
70 INSERT INTO t2 VALUES(1);
96 # cmd An INSERT or REPLACE command to execute against table t1
102 1 {} INSERT 1 {} 1
103 2 {} {INSERT OR IGNORE} 0 3 1
104 3 {} {INSERT OR REPLACE} 0 4 1
106 5 {} {INSERT OR FAIL} 1 {} 1
107 6 {} {INSERT OR ABORT} 1 {} 1
108 7 {} {INSERT OR ROLLBACK} 1 {} {}
109 8 IGNORE INSERT 0 3 1
110 9 IGNORE {INSERT OR IGNORE} 0 3 1
111 10 IGNORE {INSERT OR REPLACE} 0 4 1
113 12 IGNORE {INSERT OR FAIL} 1 {} 1
114 13 IGNORE {INSERT OR ABORT} 1 {} 1
115 14 IGNORE {INSERT OR ROLLBACK} 1 {} {}
116 15 REPLACE INSERT 0 4 1
117 16 FAIL INSERT 1 {} 1
118 17 ABORT INSERT 1 {} 1
119 18 ROLLBACK INSERT 1 {} {}
126 INSERT INTO t1 VALUES(1,2,3);
128 INSERT INTO t2 VALUES(1);
154 # cmd An INSERT or REPLACE command to execute against table t1
160 1 {} INSERT 1 {} 1
161 2 {} {INSERT OR IGNORE} 0 3 1
162 3 {} {INSERT OR REPLACE} 0 4 1
164 5 {} {INSERT OR FAIL} 1 {} 1
165 6 {} {INSERT OR ABORT} 1 {} 1
166 7 {} {INSERT OR ROLLBACK} 1 {} {}
167 8 IGNORE INSERT 0 3 1
168 9 IGNORE {INSERT OR IGNORE} 0 3 1
169 10 IGNORE {INSERT OR REPLACE} 0 4 1
171 12 IGNORE {INSERT OR FAIL} 1 {} 1
172 13 IGNORE {INSERT OR ABORT} 1 {} 1
173 14 IGNORE {INSERT OR ROLLBACK} 1 {} {}
174 15 REPLACE INSERT 0 4 1
175 16 FAIL INSERT 1 {} 1
176 17 ABORT INSERT 1 {} 1
177 18 ROLLBACK INSERT 1 {} {}
184 INSERT INTO t1 VALUES(1,2,3);
186 INSERT INTO t2 VALUES(1);
209 # cmd An INSERT or REPLACE command to execute against table t1
215 1 {} {} INSERT 1 {} 1
216 2 REPLACE {} INSERT 0 4 1
217 3 IGNORE {} INSERT 0 3 1
218 4 FAIL {} INSERT 1 {} 1
219 5 ABORT {} INSERT 1 {} 1
220 6 ROLLBACK {} INSERT 1 {} {}
221 7 REPLACE {} {INSERT OR IGNORE} 0 3 1
222 8 IGNORE {} {INSERT OR REPLACE} 0 4 1
223 9 FAIL {} {INSERT OR IGNORE} 0 3 1
224 10 ABORT {} {INSERT OR REPLACE} 0 4 1
225 11 ROLLBACK {} {INSERT OR IGNORE } 0 3 1
226 12 REPLACE IGNORE INSERT 0 3 1
227 13 IGNORE REPLACE INSERT 0 4 1
228 14 FAIL IGNORE INSERT 0 3 1
229 15 ABORT REPLACE INSERT 0 4 1
230 16 ROLLBACK IGNORE INSERT 0 3 1
231 12 IGNORE REPLACE INSERT 0 4 1
232 13 IGNORE FAIL INSERT 1 {} 1
233 14 IGNORE ABORT INSERT 1 {} 1
234 15 IGNORE ROLLBACK INSERT 1 {} {}
243 INSERT INTO t1 VALUES(1,2,3);
245 INSERT INTO t2 VALUES(1);
268 # cmd An INSERT or REPLACE command to execute against table t1
274 1 {} {} INSERT 1 {} 1
275 2 REPLACE {} INSERT 0 5 1
276 3 IGNORE {} INSERT 0 {} 1
277 4 FAIL {} INSERT 1 {} 1
278 5 ABORT {} INSERT 1 {} 1
279 6 ROLLBACK {} INSERT 1 {} {}
280 7 REPLACE {} {INSERT OR IGNORE} 0 {} 1
281 8 IGNORE {} {INSERT OR REPLACE} 0 5 1
282 9 FAIL {} {INSERT OR IGNORE} 0 {} 1
283 10 ABORT {} {INSERT OR REPLACE} 0 5 1
284 11 ROLLBACK {} {INSERT OR IGNORE} 0 {} 1
285 12 {} {} {INSERT OR IGNORE} 0 {} 1
286 13 {} {} {INSERT OR REPLACE} 0 5 1
287 14 {} {} {INSERT OR FAIL} 1 {} 1
288 15 {} {} {INSERT OR ABORT} 1 {} 1
289 16 {} {} {INSERT OR ROLLBACK} 1 {} {}
290 17 {} IGNORE INSERT 0 {} 1
291 18 {} REPLACE INSERT 0 5 1
292 19 {} FAIL INSERT 1 {} 1
293 20 {} ABORT INSERT 1 {} 1
294 21 {} ROLLBACK INSERT 1 {} {}
295 22 REPLACE FAIL INSERT 1 {} 1
296 23 IGNORE ROLLBACK INSERT 1 {} {}
307 INSERT INTO t2 VALUES(1);
321 INSERT INTO t2 VALUES(1,2,1);
322 INSERT INTO t2 VALUES(2,3,2);
323 INSERT INTO t2 VALUES(3,4,1);
324 INSERT INTO t2 VALUES(4,5,4);
327 INSERT INTO t3 VALUES(1);
376 INSERT INTO t1 SELECT * FROM t2;
400 execsql "INSERT into t1 values($i,[expr {$i+1}]);"
454 INSERT INTO t1 VALUES(1,2);
457 INSERT OR IGNORE INTO t1 VALUES(2,3);
465 INSERT OR IGNORE INTO t1 VALUES(2,4);
473 INSERT OR REPLACE INTO t1 VALUES(2,4);
481 INSERT OR IGNORE INTO t1 SELECT * FROM t1;
489 INSERT OR IGNORE INTO t1 SELECT a+2,b+2 FROM t1;
497 INSERT OR IGNORE INTO t1 SELECT a+3,b+3 FROM t1;
517 INSERT INTO t3 VALUES(1);
523 INSERT INTO t2 VALUES(1,1,1,1,1);
524 INSERT INTO t2 VALUES(2,2,2,2,2);
530 INSERT INTO t2 VALUES(1,3,3,3,3);
542 INSERT INTO t2 VALUES(3,1,3,3,3);
556 INSERT INTO t2 VALUES(3,1,3,3,3);
578 INSERT INTO t2 VALUES(3,3,3,1,3);
592 INSERT INTO t2 VALUES(3,3,3,1,3);
614 INSERT INTO t2 VALUES(3,3,3,3,1);
628 INSERT INTO t2 VALUES(3,3,3,3,1);
650 INSERT INTO t2 VALUES(3,3,1,3,3);
664 INSERT INTO t2 VALUES(3,3,1,3,3);
677 INSERT INTO t1 VALUES(1,2);
678 INSERT INTO t1 VALUES(1,3);
688 INSERT INTO t4 VALUES(1);
689 INSERT INTO t4 VALUES(1);