DELIMITER $$
USE `b`; $$
DROP TRIGGER IF EXISTS `b`.`bbib`; $$
CREATE TRIGGER `b`.`bbib` BEFORE INSERT
ON `b`.`bb` FOR EACH ROW
BEGIN
SET new.servers := 'b';
END; $$
如果有什么初始值需要设置 放入before
DELIMITER $$
USE `b`; $$
DROP TRIGGER IF EXISTS `b`.`bbia`; $$
CREATE TRIGGER `b`.`bbia` AFTER INSERT
ON `b`.`bb` FOR EACH ROW
BEGIN
IF (new.servers = 'b') THEN
INSERT INTO `a`.`aa`(`uuid`,`servers`,`type`,`name`)VALUES(new.uuid,'b',new.type,new.`name`);
END IF;
USE `b`; $$
DROP TRIGGER IF EXISTS `b`.`bbib`; $$
CREATE TRIGGER `b`.`bbib` BEFORE INSERT
ON `b`.`bb` FOR EACH ROW
BEGIN
SET new.servers := 'b';
END; $$
如果有什么初始值需要设置 放入before
DELIMITER $$
USE `b`; $$
DROP TRIGGER IF EXISTS `b`.`bbia`; $$
CREATE TRIGGER `b`.`bbia` AFTER INSERT
ON `b`.`bb` FOR EACH ROW
BEGIN
IF (new.servers = 'b') THEN
INSERT INTO `a`.`aa`(`uuid`,`servers`,`type`,`name`)VALUES(new.uuid,'b',new.type,new.`name`);
END IF;
END; $$
数据提交回写尽力放到after