update语句条件判断更新
摘要:
UPDATE cw_party tp,cw_shop ts SET tp.state = 3, ts.bonus_average = CASE WHEN ts.bonus_average > 0 THEN (50 + ts.bonus_average) / 2 ELSE 50 END, tp.upd 阅读全文
posted @ 2017-11-14 11:47 果然朝辉 阅读(10688) 评论(0) 推荐(0) 编辑