插入语句
<p>1.储值卡插入语句
insert into g_chuzk(c_rfkah,c_rfwulbh,c_shopid,c_vipbh,m_rfkaje,c_rfkazt,c_xingm,c_xingb,c_rfkbh) select 'UZC1111'||c_vipkh,'UZC1111'||c_vipkh,shopid,'UZC1111'||c_vipkh, c_jie ,'KK',c_vipxm,'男'as c_sex,'UZC1111'||c_vipkh from bojun.t_chuzk
//更新储值卡归属店铺 update g_chuzk set c_shopid='370802001' //更新储值卡的时效日期 update g_chuzk set d_beiyzd1='2024-06-18 09:17:50.527316'
导入完后， 运行PHP（<a href="http://pose.honggu.cn:202/9internet/zmdserver/chuzk_refresh.php">http://pose.honggu.cn:202/9internet/zmdserver/chuzk_refresh.php</a>)</p>
<p>2.导入会员语句
insert into g_vip (c_shopid, c_vipkh ,n_leix ,c_xingm, c_sex, c_soujhm, d_birthday, c_vipbh, m_jinebd, m_jine, c_sengrlx) select c_shopid, c_vipkh ,n_leix ,c_xingm, c_sex, c_soujhm, d_birthday, c_vipbh, m_jinebd, m_jine, c_sengrlx from t_vipxin</p>
<p>3.会员积分查询 分公司查看 插入语句
INSERT into g_dianpqx select u_id,n_id,d_id,c_id,d_upid,c_upid,c_upztm,c_xuh,'88888005', c_quanxbh,c_quanxmc,c_quanxdh,c_quanxvalue,c_morvalue,c_leib,c_quanxsm, c_zuidz,c_zuixz ,c_beiz from g_dianpqx
where shopid ='88888' and c_quanxbh='g_CanCKVipjx' </p>