Tuesday, July 30, 2013

MySql Update Trigger

DELIMITER $$

DROP TRIGGER `rfc`.`insert_approval_data_update`$$

CREATE TRIGGER `rfc`.`insert_approval_data_update` AFTER UPDATE on `rfc`.`dbrassessment`
FOR EACH ROW BEGIN
UPDATE report_one SET approved_ammount = NEW.LoanAmountRec,approved_tenor = NEW.TenureRec,Interest_Rate = NEW.InterestRateRec,EMI = NEW.EmiRec,dbr_ratio = NEW.DbrAsPerSlabrec WHERE fileSerial = NEW.fileSerial;
END$$

DELIMITER ;

No comments:

Post a Comment