导入省:
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