DELIMITER $
Create PROCEDURE recharge (PName varchar(100),gold int(10))
BEGIN
set @AName=CONCAT('1-',PName);
set @AccountID=(select AccountID from avatar where rolename=@AName);
update avatar set Diamond=Diamond+gold where RoleName=@AName;
update account set RechargeTotal=RechargeTotal+gold where AccountID=@AccountID;
end$
delimiter ;
支持太棒了,感谢楼主漂亮~
支持楼主~~~
热门手游【龙骑战歌】架设教程 [修改]
➨➨➨➨➨冰蓝娱乐【只存在于传说当中】,太棒了,感谢楼主
➨➨➨➨➨冰蓝娱乐【只存在于传说当中】,太棒了,感谢楼主
➨➨➨➨➨冰蓝娱乐【只存在于传说当中】,太棒了,感谢楼主
➨➨➨➨➨冰蓝娱乐【只存在于传说当中】,哈哈!太好笑了.
➨➨➨➨➨冰蓝娱乐【只存在于传说当中】,拿分走人呵呵,楼下继续!
➨➨➨➨➨冰蓝娱乐【只存在于传说当中】,拿分走人呵呵,楼下继续!