Tuesday, July 30, 2013

MySql Insert Trigger



 DELIMITER $$

DROP TRIGGER `rfc`.`after_insert_new_file`$$

create trigger `rfc`.`after_insert_new_file` AFTER INSERT on `rfc`.`customer_info`
for each row BEGIN
INSERT INTO report_one (fileSerial,Status,Sla_Date,Source_id,Source_Name,Cluster,app_Date,applicants_Name,Applied_Ammount,Applied_Tenor,age,Home_Phone,Present_Area,Parmanent_Area)
        VALUES (NEW.fileSerial,NEW.status,NEW.Sla_Date,NEW.introducer_id,NEW.Branch,NEW.Cluster,NEW.AppDate,NEW.applicantsName,NEW.applied_amount,NEW.loanTenor,NEW.ageCalculate,NEW.homePhoneMobile,NEW.presentArea,NEW.permanentArea);
END;
$$

DELIMITER ;

No comments:

Post a Comment