1 2 3 4 5 6 7 8 9 10 11 12 13
CREATE TABLE t1(a, b, c); CREATE TABLE t2(x, y, z); CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN UPDATE t1 SET a=x FROM t2 WHERE c=z; END; INSERT INTO t2 VALUES(1, 1, 1); INSERT INTO t2 VALUES(2, 2, 2); INSERT INTO t2 VALUES(3, 3, 3);