昆仑会员系统批量准确更新员工卡等级

SELECT membership_type from member_info_svc WHERE linkman_tel = '13930226479' --查询单挑卡记录

SELECT * from member_info_svc m , dic_vip_level_svc b WHERE m.membership_type=b.membership_code AND chname ='浩秦' --联查

update member_info_svc SET VIP_level = '4' where  chname = '浩秦' --更新单条卡等级

SELECT * FROM dic_vip_level_svc --查询卡等级

SELECT * INTO ll_dic_vip_level_svc FROM dic_vip_level_svc --插入新表

SELECT * INTO ll_num FROM member_info_svc --插入新表

SELECT * from ll_dic_vip_level_svc;
--SELECT * from member_info_svc     
SELECT * from ll_member_info_svc l,ll_num m where l.linkman_tel=m.linkman_tel; --联查
UPDATE ll_member_info_svc SET VIP_level = '4' FROM ll_member_info_svc l,ll_num m where l.linkman_tel=m.linkman_tel; --联查手机号码更新

更新

SELECT * INTO ll_num FROM member_info_svc --插入新表
SELECT * FROM member_info_svc where membership_type ='HZYHQQK' and VIP_level='5' --查询是否是员工权益卡

SELECT * from member_info_svc l,landv_update m where l.linkman_tel=m.phone and  membership_type ='HZYHQQK'; --联查

UPDATE member_info_svc Set VIP_level='5' FROM member_info_svc l,landv_update m where  l.linkman_tel=m.phone and  membership_type ='HZYHQQK'; --联查手机号码更新SELECT name,phone from landv_update  except select chname,linkman_tel from member_info_svc --比较数据差异，数据多的要在前面

landv / landv.github.io

昆仑会员系统批量准确更新员工卡等级 #62