mysql更新触发器

1.满足条件执行，在可视化界面写的

BEGIN
	SET @status = (SELECT status FROM orders WHERE orders.`sign`=new.sign OR orders.orderId=new.orderId);
	IF  (@status = 2) OR (@status=3) THEN
		SET new.status=@status;
	END IF;
END

2.根据一个表中的字段更新另外一张表

BEGIN 
SET @paystatus = (SELECT paystatus FROM orders WHERE orders.`sign`=new.sign OR orders.orderId=new.orderId);
SET @cpsign = (SELECT cpsign FROM orders WHERE orders.`sign`=new.sign OR orders.orderId=new.orderId);
IF @paystatus='D' THEN
UPDATE coupon set status='1' where coupon.code=@cpsign;
ELSEIF @paystatus='0' THEN
UPDATE coupon set status='0' where coupon.code=@cpsign;
ELSEIF @paystatus='1' THEN
UPDATE coupon set status='2' where coupon.code=@cpsign;
END IF;
END