mysql

 

 

<update id="updateAccount" parameterType="Object" >
update member set editdate=now(),bonus=ifnull(bonus,0)+#{bonus},money=ifnull(money,0)+#{money},orderTicket=ifnull(orderTicket,0)+#{orderTicket }
<if test="colddays !=null and colddays >=0">
,colddays=#{colddays}
</if>
where id=#{id}
</update>