Lines Matching refs:INSERT

55 	CREATE TRIGGER tr1 INSERT ON t1 BEGIN
56 	  INSERT INTO t1 values(1);
70 	CREATE TRIGGER tr2 INSERT ON t1 BEGIN
73 	CREATE TRIGGER tr2 INSERT ON t1 BEGIN
197     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
204     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
218     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
219       INSERT INTO t2 VALUES(NEW.a,NEW.b);
225     INSERT INTO t1 VALUES(1,2);
237     INSERT INTO t1 VALUES(1,2);
244     INSERT INTO t1 VALUES(1,2);
251     CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
252       INSERT INTO t2 VALUES(NEW.a,NEW.b);
254     INSERT INTO t1 VALUES(1,2);
267     INSERT INTO t1 VALUES(3,4);
275     INSERT INTO t1 VALUES(5,6);
282     CREATE TEMP TRIGGER r1 BEFORE INSERT ON t1 BEGIN
283       INSERT INTO t2 VALUES(NEW.a,NEW.b);
285     INSERT INTO t1 VALUES(7,8);
292     INSERT INTO t1 VALUES(9,10);
363     CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
375     CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
387     CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
404     CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
407     INSERT INTO t3 VALUES(1,2);
413     INSERT INTO t3 VALUES(1,3);
450     CREATE TEMP TRIGGER trig1 AFTER INSERT ON t1 BEGIN 
451       INSERT INTO insert_log VALUES('main', new.a, new.b, new.c);
453     CREATE TEMP TRIGGER trig2 AFTER INSERT ON t2 BEGIN 
454       INSERT INTO insert_log VALUES('temp', new.a, new.b, new.c);
456     CREATE TEMP TRIGGER trig3 AFTER INSERT ON t3 BEGIN 
457       INSERT INTO insert_log VALUES('aux', new.a, new.b, new.c);
463     INSERT INTO t1 VALUES(1, 2, 3);
464     INSERT INTO t2 VALUES(4, 5, 6);
465     INSERT INTO t3  VALUES(7, 8, 9);
476     INSERT INTO t1 VALUES(1, 2, 3);
477     INSERT INTO t2 VALUES(4, 5, 6);
478     INSERT INTO t3  VALUES(7, 8, 9);
490     INSERT INTO t1 VALUES(11, 12, 13);
491     INSERT INTO t2 VALUES(14, 15, 16);
492     INSERT INTO t3 VALUES(17, 18, 19);
511     INSERT INTO t1 VALUES(21, 22, 23);
512     INSERT INTO t2 VALUES(24, 25, 26);
513     INSERT INTO t3  VALUES(27, 28, 29);