数据导入

导入省:
insert into pub_province(subname,code) select province,provinceID from province


导入市:注意ordercode为定位码
insert into pub_city(subname,code,ordercode) select city,cityID,father from city
update pub_city set pub_city._cid=pub_province.cid from pub_province where pub_city.ordercode=pub_province.code

导入县:
insert into pub_district(subname,code,ordercode) select area,areaID,father from area
update pub_district set pub_district._cid=pub_city.cid from pub_city where pub_district.ordercode=pub_city.code

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值