Lines Matching refs:INSERT
26 INSERT INTO t1 VALUES(1,2);
27 INSERT INTO t1 VALUES(3,4);
95 INSERT INTO t1(rowid,x,y) VALUES(1234,5,6);
107 INSERT INTO t1(y,x,oid) VALUES(8,7,1235);
119 INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10);
171 INSERT INTO t2 VALUES(0,2,3);
172 INSERT INTO t2 VALUES(4,5,6);
173 INSERT INTO t2 VALUES(7,8,9);
204 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
206 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
310 INSERT INTO t1 VALUES(1,2);
316 INSERT INTO t1 VALUES(99,100);
323 INSERT INTO t2(b) VALUES(55);
329 INSERT INTO t2(b) VALUES(66);
335 INSERT INTO t2(a,b) VALUES(1000000,77);
336 INSERT INTO t2(b) VALUES(88);
342 INSERT INTO t2(a,b) VALUES(2147483647,99);
343 INSERT INTO t2(b) VALUES(11);
354 INSERT INTO t2(b) VALUES(22);
355 INSERT INTO t2(b) VALUES(33);
356 INSERT INTO t2(b) VALUES(44);
357 INSERT INTO t2(b) VALUES(55);
364 INSERT INTO t2(b) VALUES(111);
376 INSERT INTO t4 VALUES(1);
377 CREATE TRIGGER r3 AFTER INSERT on t3 FOR EACH ROW BEGIN
378 INSERT INTO t4 VALUES(NEW.a+10);
390 INSERT INTO t3 VALUES(123);
406 INSERT INTO t3 VALUES(NULL);
481 INSERT INTO t5 VALUES(1);
482 INSERT INTO t5 VALUES(2);
483 INSERT INTO t5 SELECT a+2 FROM t5;
484 INSERT INTO t5 SELECT a+4 FROM t5;
552 INSERT INTO t6(rowid,a) SELECT -a,a FROM t5;