Lines Matching refs:INSERT

28     INSERT INTO t1 VALUES(1,2);
29     INSERT INTO t1 VALUES(3,4);
97     INSERT INTO t1(rowid,x,y) VALUES(1234,5,6);
109     INSERT INTO t1(y,x,oid) VALUES(8,7,1235);
121     INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10);
173     INSERT INTO t2 VALUES(0,2,3);
174     INSERT INTO t2 VALUES(4,5,6);
175     INSERT INTO t2 VALUES(7,8,9);
206     execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
208   execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
312     INSERT INTO t1 VALUES(1,2);
318     INSERT INTO t1 VALUES(99,100);
325     INSERT INTO t2(b) VALUES(55);
331     INSERT INTO t2(b) VALUES(66);
337     INSERT INTO t2(a,b) VALUES(1000000,77);
338     INSERT INTO t2(b) VALUES(88);
344     INSERT INTO t2(a,b) VALUES(2147483647,99);
345     INSERT INTO t2(b) VALUES(11);
356     INSERT INTO t2(b) VALUES(22);
357     INSERT INTO t2(b) VALUES(33);
358     INSERT INTO t2(b) VALUES(44);
359     INSERT INTO t2(b) VALUES(55);
366     INSERT INTO t2(b) VALUES(111);
378     INSERT INTO t4 VALUES(1);
379     CREATE TRIGGER r3 AFTER INSERT on t3 FOR EACH ROW BEGIN
380       INSERT INTO t4 VALUES(NEW.a+10);
392     INSERT INTO t3 VALUES(123);
408     INSERT INTO t3 VALUES(NULL);
483     INSERT INTO t5 VALUES(1);
484     INSERT INTO t5 VALUES(2);
485     INSERT INTO t5 SELECT a+2 FROM t5;
486     INSERT INTO t5 SELECT a+4 FROM t5;
554     INSERT INTO t6(rowid,a) SELECT -a,a FROM t5;