mysql条件下触发_如果条件存在,则触发MySQL

我认为你的意思是在没有提供新密码时将其更新回OLD密码.

DROP TRIGGER IF EXISTS upd_user;

DELIMITER $$

CREATE TRIGGER upd_user BEFORE UPDATE ON `user`

FOR EACH ROW BEGIN

IF (NEW.password IS NULL OR NEW.password = '') THEN

SET NEW.password = OLD.password;

ELSE

SET NEW.password = Password(NEW.Password);

END IF;

END$$

DELIMITER ;

但是,这意味着用户永远不会删除密码.

如果密码字段(已加密)在更新中发送回mySQL,则它将不为空或空白,并且MySQL将尝试重做其上的Password()函数.要检测到这一点,请改用此代码

DELIMITER $$

CREATE TRIGGER upd_user BEFORE UPDATE ON `user`

FOR EACH ROW BEGIN

IF (NEW.password IS NULL OR NEW.password = '' OR NEW.password = OLD.password) THEN

SET NEW.password = OLD.password;

ELSE

SET NEW.password = Password(NEW.Password);

END IF;

END$$

DELIMITER ;