不同库 不同表 不同字段 数据同步 触发器

DELIMITER $$

USE `first`$$

DROP TRIGGER /*!50032 IF EXISTS */ `ziduan`$$

CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `ziduan` AFTER INSERT ON `miss`
    FOR EACH ROW BEGIN
    INSERT INTO f1.`user`(username,PASSWORD) SELECT username ,PASSWORD FROM first.`miss`;
    END;
$$

DELIMITER ;

DELIMITER $$

USE `kezi`$$

DROP TRIGGER /*!50032 IF EXISTS */ `add`$$

CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `add` AFTER INSERT ON `ehecd_member`
    FOR EACH ROW BEGIN
    INSERT INTO kezi_copy.`t_user`(userName ,userPassword,RealName,userHeadUrl,email,sex,birthday,tel,LoginTimes,lastLoginTime,QQ,QQopenid,lastLoginIp,registerTime) SELECT member_name,member_passwd,member_truename,member_avatar,member_email,member_sex,member_birthday,member_mobile,member_login_num,member_old_login_time,member_qq,member_qqopenid,member_old_login_ip,member_time  FROM kezi.`ehecd_member`;
    END;
$$

DELIMITER ;