DROP TRIGGER IF EXISTS `t_afterupdate_on_oepre_user_params`; DELIMITER // CREATE TRIGGER `t_afterupdate_on_oepre_user_params` AFTER UPDATE ON `oepre_user_params` FOR EACH ROW begin IF(new.rzemial=1) THEN DELETE FROM oepre_promotion WHERE ruserid = new.userid ; END IF ; END // DELIMITER ;
DELIMITER //
CREATE TRIGGER `t_afterupdate_on_oepre_user_params` AFTER UPDATE ON `oepre_user_params`
FOR EACH ROW begin
IF(new.rzemial=1) THEN
DELETE FROM oepre_promotion WHERE ruserid = new.userid ;
END IF ;
END
//
DELIMITER ;