Create MySQL trigger
For update
CREATE TRIGGER TRG_tableA_Insert
AFTER INSERT
ON tableA FOR EACH ROW
BEGIN
UPDATE tableB
set columnA = NEW.columnX,
columnB = NEW.columnY,
WHERE columnB = NEW.columnY;
END;
For insert
CREATE TRIGGER TRG_tableA_Insert
AFTER INSERT
ON tableA FOR EACH ROW
BEGIN
INSERT INTO tableB(columnA, columnB)
VALUES ( NEW.columnX, NEW. columnY);
END;
