Lines Matching refs:INSERT
53 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
54 INSERT INTO t1 values(1);
68 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
71 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
195 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
202 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
216 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
217 INSERT INTO t2 VALUES(NEW.a,NEW.b);
223 INSERT INTO t1 VALUES(1,2);
235 INSERT INTO t1 VALUES(1,2);
242 INSERT INTO t1 VALUES(1,2);
249 CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
250 INSERT INTO t2 VALUES(NEW.a,NEW.b);
252 INSERT INTO t1 VALUES(1,2);
265 INSERT INTO t1 VALUES(3,4);
273 INSERT INTO t1 VALUES(5,6);
280 CREATE TEMP TRIGGER r1 BEFORE INSERT ON t1 BEGIN
281 INSERT INTO t2 VALUES(NEW.a,NEW.b);
283 INSERT INTO t1 VALUES(7,8);
290 INSERT INTO t1 VALUES(9,10);
361 CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
373 CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
385 CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
402 CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
405 INSERT INTO t3 VALUES(1,2);
411 INSERT INTO t3 VALUES(1,3);
448 CREATE TEMP TRIGGER trig1 AFTER INSERT ON t1 BEGIN
449 INSERT INTO insert_log VALUES('main', new.a, new.b, new.c);
451 CREATE TEMP TRIGGER trig2 AFTER INSERT ON t2 BEGIN
452 INSERT INTO insert_log VALUES('temp', new.a, new.b, new.c);
454 CREATE TEMP TRIGGER trig3 AFTER INSERT ON t3 BEGIN
455 INSERT INTO insert_log VALUES('aux', new.a, new.b, new.c);
461 INSERT INTO t1 VALUES(1, 2, 3);
462 INSERT INTO t2 VALUES(4, 5, 6);
463 INSERT INTO t3 VALUES(7, 8, 9);
474 INSERT INTO t1 VALUES(1, 2, 3);
475 INSERT INTO t2 VALUES(4, 5, 6);
476 INSERT INTO t3 VALUES(7, 8, 9);
488 INSERT INTO t1 VALUES(11, 12, 13);
489 INSERT INTO t2 VALUES(14, 15, 16);
490 INSERT INTO t3 VALUES(17, 18, 19);
509 INSERT INTO t1 VALUES(21, 22, 23);
510 INSERT INTO t2 VALUES(24, 25, 26);
511 INSERT INTO t3 VALUES(27, 28, 29);