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$

 

posted @ 2014-11-03 13:47  吉利来  阅读(131)  评论(0编辑  收藏  举报