新闻动态

删除会员卡的保底额(V6系列、Z7系列、V9商业、V10系列)

2019-03-04 21:51:17

A、删除某张卡的保底额:(不管有没有发行)

update pos_t_vip_info set least_cash=0 where card_id='卡号'

B、删除所有卡的保底额:(不管有没有发行)

update pos_t_vip_info set least_cash=0 where least_cash<>0

C、删除所有未发行卡的保底额:

update pos_t_vip_info set least_cash=0 where least_cash<>0 and card_status='3'

D、删除某个会员类别未发行卡的保底额:

update pos_t_vip_info set least_cash=0 where least_cash<>0 and card_type='两位会员分类编号' and  card_status='3'

E、删除某个会员类别会员卡的保底额:(不管有没有发行)

update pos_t_vip_info set least_cash=0 where least_cash<>0 and card_type='两位会员分类编号'