这是原来的一个
set names GBK;update account_common set yuanbao_recharge=yuanbao_recharge+{money} where account_id=(SELECT account_id FROM role_data where role_name='{account}');
现在我想改两个地方该怎么写呢。一个是数值是充值的110%,一个写成1
where rechargeId ={account}
where amount = money_rmb
rechargeAmount=amount乘以110%
state=1
也就是说如果rechargeId和amount与充值资料一样,那么rechargeAmount写成amount乘以110%,state写成1