删除会员卡的保底额(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='两位会员分类编号'