CREATE TABLE tableABC (id VARCHAR(255) UNIQUE);
CREATE TRIGGER tr_bi_a BEFORE INSERT ON tableA
FOR EACH ROW INSERT INTO tableABC VALUES (NEW.id);
CREATE TRIGGER tr_bi_b BEFORE INSERT ON tableB
FOR EACH ROW INSERT INTO tableABC VALUES (NEW.id);
CREATE TRIGGER tr_bi_c BEFORE INSERT ON tableC
FOR EACH ROW INSERT INTO tableABC VALUES (NEW.id);
|