画像
update DAPM_GU_BDM_LABEL_PORTRAIT_A set --注智-离网倾向(集团)RESERV252 = '潜在闲时流量包营销用户,潜在副卡',--注智-渠道偏好(集团)RESERV250 = '10000号',--家庭类型(集团)RESERV239 = '二人世界',--注智-业务偏好(集团)RESERV253 = '高流量套餐',--社会分群(集团)RESERV240 = '高端精英',--上网（兴趣）偏好(集团)RESERV249 = '购物',--职业标签(集团)RESERV241 = '技术专家',--注智-消费潜力(集团)RESERV246 = '高',--流量特征(集团)RESERV247 = '4',--注智-服务信息(集团)RESERV254 = '搜狗搜索',--出国人群(集团)RESERV7 = '否',--注智-终端品牌偏好(集团)RESERV245 = '荣耀'--注智-偏好终端品牌(集团)--RESERV244 where accs_nbr = '18940000385' ; update cust_labelset UV0001 = '科普频道'where PB0041='18940000396';星级
update cust_label set --翼支付余额 UV0002 = '20',--翼支付星级 UV0003 = '3',--翼支付活跃次数 UV0004 = '5',--当月是否翼支付消费活跃用户 UV0005 = '是',--是否翼支付绑卡用户 UV0006 ='是'where PB0041='18940000385';终端
update cust_label set UV0011 = 'HW-KIW CL00',-- 手机在用终端(T1)UV0012 = '否',-- 是否合约机(T1)UV0013 = '',-- 合约计划(T1)UV0014 = 'T1',-- 终端使用轨迹(T1)UV0015 = '华为',-- 终端品牌(T1)UV0016 = '20180128',-- 终端激活时间(T1)UV0017 = 'A00000598AAC17',-- 终端串码(T1)UV0018 = '',-- 终端激活地点(T1)UV0019 = '',-- 光猫在用终端(T1)UV0020 = 'HW-HUAWEI C8813',-- 手机在用终端(T2)UV0021 = '否',-- 是否合约机(T2)UV0022 = '',-- 合约计划(T2)UV0023 = 'T2',-- 终端使用轨迹(T2)UV0024 = '华为',-- 终端品牌(T2)UV0025 = '20140620',-- 终端激活时间(T2)UV0026 = 'A00000433623F6',-- 终端串码(T2)UV0027 = '',-- 终端激活地点(T2)UV0028 = '',-- 光猫在用终端(T2)UV0029 = 'ZTE-C N760',-- 手机在用终端(T3)UV0030 = '否',-- 是否合约机(T3)UV0031 = '',-- 合约计划(T3)UV0032 = 'T3',-- 终端使用轨迹(T3)UV0033 = '中兴',-- 终端品牌(T3)UV0034 = '20140101',-- 终端激活时间(T3)UV0035 = 'A000003210B204',-- 终端串码(T3)UV0036 = '',-- 终端激活地点(T3)UV0037 = '' -- 光猫在用终端(T3) where PB0041='18940000396';