触发器

CREATE TRIGGER `currentdata_update` AFTER UPDATE ON `currentdata`

FOR EACH ROW 
BEGIN

insert into currentdatalog(F_Craft,F_Machine,F_PropertySn,F_PropertyTitle,F_PropertyVal,F_Statue,F_Ratio,F_SortCode)
values(new.F_Craft,new.F_Machine,new.F_PropertySn,new.F_PropertyTitle,new.F_PropertyVal,new.F_Statue,new.F_Ratio,new.F_SortCode);



END;