mysql 触发器示例

DROP TRIGGER IF EXISTS `t_user_update`;
DELIMITER $$
CREATE TRIGGER `t_user_update` 
AFTER UPDATE ON user
 FOR EACH ROW  
  BEGIN   

    /*修改批次状态*/
    DECLARE userStatus_ INT;

      SELECT  cs.userStatus INTO userStatus_ FROM user cs WHERE cs.id = OLD.id;

      IF(user= 1) THEN
         UPDATE user SET userStatus = userStatus_ WHERE id= OLD.id;
      END IF;
END
$$
DELIMITER ;

触发器基础示例，其中OLD为触发器更新后可以拿到的参数，NEW则为插入后可以拿到的参数。