mysql不同数据库间数据传输触发器

DELIMITER $
create trigger tg_insert1
after insert on chaes.rain_day
for each row
begin
INSERT INTO ces_basedata.rain_day(idraincode,dt,p) values (new.idraincode,new.dt,new.p) ON DUPLICATE KEY
update ces_basedata.rain_day.p=values(p);
end$

create trigger tg_update1
after update on chaes.rain_day
for each row
begin
insert into ces_basedata.rain_day(idraincode,dt,p) values (new.idraincode,new.dt,new.p) ON DUPLICATE KEY
update ces_basedata.rain_day.p=values(p);
end$

create trigger tg_insert2
after insert on chaes.rain_interval
for each row
begin
INSERT INTO ces_basedata.rain_interval(idraincode,dt,p) values (new.idraincode,new.dt,new.p) ON DUPLICATE KEY
update ces_basedata.rain_interval.p=values(p);
end$

create trigger tg_update2
after update on chaes.rain_interval
for each row
begin
insert into ces_basedata.rain_interval(idraincode,dt,p) values (new.idraincode,new.dt,new.p) ON DUPLICATE KEY
update ces_basedata.rain_interval.p=values(p);
end$