Mysql5.7.21 Navicat触发器创建

佚名 5年前 (2019-03-23) Mysql 765人围观抢沙发百度已收录

CREATE TRIGGER m_trigger AFTER UPDATE ON table1
FOR EACH ROW
BEGIN
IF( old.status!= new.status)
THEN
SELECT COUNT(id) FROM table1 WHERE stats='Y' INTO @yCount;

SELECT max(num) from table2 INTO @maxYCount;
IF( @yCount> @maxYCount)
THEN
insert into table2 (num) select count(1) from table1 b where b.statu='Y';
END IF;
END IF;
END

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

注：mysql中变量不用事先声明，用时直接‘@变量名’使用。

1、set @num=1; set @num:=1;

2、SELECT COUNT(id) FROM table1 WHERE stats='Y' INTO @yCount;