CREATE TRIGGER testref BEFORE INSERT ON A FOR EACH ROW BEGINUPDATE B SET `password`=NEW.`password`; END;
DELIMITER $$CREATE TRIGGER `aa`.`AA` BEFORE UPDATE ON `aa`.`AA1` FOR EACH ROW BEGIN UPDATE AA2 SET `password`=NEW.`password` WHERE NAME=NEW.NAME; END$$DELIMITER ;
CREATE TRIGGER tr_A AFTER UPDATE ON A FOR EACH ROW UPDATE B SET `password`=NEW.`password`;
FOR EACH ROW BEGINUPDATE B SET `password`=NEW.`password`;
END;
ON `aa`.`AA1`
FOR EACH ROW BEGIN
UPDATE AA2 SET `password`=NEW.`password` WHERE NAME=NEW.NAME;
END$$DELIMITER ;
FOR EACH ROW
UPDATE B SET `password`=NEW.`password`;