CREATE TRIGGER tra1
AFTER INSERT ON ALIPAY
FOR EACH ROR
BEGIN
UPDATE STORE SET STORECOMM=STORECOMM+NEW.TOTAL_FREE WHERE STOREID=NEW.STOREID;
END$
CREATE TRIGGER tra1
AFTER INSERT ON ALIPAY
FOR EACH ROR
BEGIN
UPDATE STORE SET STORECOMM=STORECOMM+NEW.TOTAL_FREE WHERE STOREID=NEW.STOREID;
END$