MYSQL语句内加判断力

update  `InApp_WalletPoint` set `point`= case when (`point`-3900)>=0 then (`point`-3900) else 0 end where uid=76705;

 

posted @ 2013-09-03 14:40  jshaibozhong  阅读(154)  评论(0编辑  收藏  举报