里面主要说的是同一个地址2个不同数据库之前的操作,a数据库里面A表数据有 新增、修改、删除时,去触发下面的函数,然后对b数据库里面的B表做对应的操作(A表B表结构可以说是相同的)
DROP TRIGGER IF EXISTS `add_rma_order`;
DELIMITER ;;CREATE TRIGGER `add_rma_order` AFTER INSERT ON `tp_user_rma_order_descript` FOR EACH ROW BEGIN
DECLARE oid INT DEFAULT 0;
DECLARE path varchar(100) DEFAULT 'http://www.mypgy.com';
SELECT rma.id into oid from ptoa.rma_order_descript as rma
where rma.order_id=new.order_id;
if(oid>0) THEN
UPDATE ptoa.rma_order_descript as rma set
rma.uid=(SELECT oa_id FROM tp_user_info WHERE uid=new.uid),
rma.addr_front=new.addr_front,rma.addr_last=new.addr_last,rma.do_addr_front=new.do_addr_front,rma.do_addr_last=new.do_addr_last,
rma.tel=new.tel,rma.bill_img=concat(path,new.bill_img),rma.bank_img=concat(path,new.bank_img),rma.do_supplier=