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 ;