CREATE
TRIGGER `触发器名` BEFORE UPDATE ON `表名`
FOR EACH ROW BEGIN
IF old.effec_number <> 0 AND new.effec_number = 0 THEN
SET new.effec_number = 255;
END IF;
END;
CREATE
TRIGGER `触发器名` BEFORE UPDATE ON `表名`
FOR EACH ROW BEGIN
IF old.effec_number <> 0 AND new.effec_number = 0 THEN
SET new.effec_number = 255;
END IF;
END;