如何删除某一个微信会员
如果要删除微信会员的话,为了避免该客户重新注册报错,需要删除对应的该会员的所有记录:-----------------谨慎使用-------------------------
deletefrom bas_vip where vip_id ='VIP卡号'
deletefrom ACC_VIP_INTEGAL where vip_id = 'VIP卡号'
deletefrom Bas_Card where vip_id = 'VIP卡号'
delete fromCard_CKRK_DTL where Card_id ='VIP卡号''
update bas_vip_weixin set vip_id = NULL,vip_shp_id = null where vip_id = 'VIP卡号'
delete Acc_Card_Store where Card_id = '1030528'
页:
[1]