Mysql 触发器

CREATE TRIGGER  tra1

AFTER INSERT ON ALIPAY  

FOR EACH ROR

BEGIN

UPDATE STORE SET STORECOMM=STORECOMM+NEW.TOTAL_FREE WHERE STOREID=NEW.STOREID;

END$

原文地址:https://www.cnblogs.com/zhuangjixiang/p/4071036.html