sagarPakhrin/creating_trigger.md

## creating_trigger.md

      
    Raw
  

              creating_trigger.md
            
          
    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 ;