cara membuat mysql trigger

 

BEGIN
INSERT INTO log_erp_gm
set documentNo = OLD.documentNo,
productId=old.productId,
productId_baru=new.productId,
idCurrentBin=old.idCurrentBin,
idCurrentBin_baru=new.idCurrentBin,
idLine=old.idLine,
idLine_baru=new.idLine,
idBinBoardingTransit=old.idBinBoardingTransit,
idBinBoardingTransit_baru=new.idBinBoardingTransit
;
END

Bagikan Artikel ini