mysql触发器出发后更改另一张表的字段
CREATE TRIGGER rechargefee AFTER insert ON recharge
FOR EACH ROW
BEGIN
update user set balance=balance+new.chargefee where phone=new.chargephone;
END;
mysql触发器出发后更改另一张表的字段
CREATE TRIGGER rechargefee AFTER insert ON recharge
FOR EACH ROW
BEGIN
update user set balance=balance+new.chargefee where phone=new.chargephone;
END;