⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 zipcodeinsert04.sql

📁 全国邮政编码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
INSERT INTO ZipCode VALUES (    150148,'赤岭、那寮、西松、上莞','524131','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150149,'那纯、坡塘村','524131','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150150,'愚公楼村','524131','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150151,'龙群那爱村','524132','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150152,'曲界镇','524132','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150153,'锦和镇','524133','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150154,'新寮镇','524134','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150155,'后湾、北塘村','524135','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150156,'外罗镇','524135','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150157,'下洋镇','524136','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150158,'前山镇','524137','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150159,'白沙村','524139','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150160,'龙塘镇','524139','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150161,'海安镇','524145','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150162,'角尾乡','524146','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150163,'迈陈镇','524146','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150164,'那练、白坡、青桐、官田村','524146','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150165,'西连镇','524147','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150166,'城北农场、三阳桥水库','524148','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150167,'下桥镇','524148','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150168,'信桥、坑仔村','524149','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150169,'高田、石板村','524151','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150170,'和安镇','524155','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150171,'白沙乡','524200','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150172,'附城乡、白沙乡及所属各村','524200','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150173,'雷州市','524200','广东','广东','y');
INSERT INTO ZipCode VALUES (    150174,'平余、孟山、揖花村','524200','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150175,'县城(雷城镇','524200','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150176,'客路镇','524231','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150177,'沈塘镇','524239','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150178,'雷高镇','524241','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150179,'东里镇','524242','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150180,'调风镇','524243','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150181,'下海村','524251','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150182,'英利镇','524251','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150183,'流沙、提交村','524252','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150184,'铺仔、陈宅村','524254','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150185,'覃斗乡','524254','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150186,'房参乡','524255','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150187,'乌石镇','524255','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150188,'北和镇','524256','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150189,'企水镇、海田乡及所属各村','524257','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150190,'唐家镇','524265','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150191,'纪家镇','524266','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150192,'杨家乡','524267','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150193,'松竹镇','524268','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150194,'南兴镇','524269','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150195,'山美、马铁、方家、八龙、','524269','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150196,'五坑村','524269','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150197,'龙门镇','524272','雷州市','广东','n');
INSERT INTO ZipCode VALUES (    150198,'城西乡','524300','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150199,'附城乡','524300','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150200,'遂城镇、城西乡及所属各村','524300','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150201,'遂溪县','524300','广东','广东','y');
INSERT INTO ZipCode VALUES (    150202,'县城(遂城镇','524300','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150203,'大岭、官湖村','524334','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150204,'平石、坑尾、黄爱、南停村','524334','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150205,'黄略镇','524335','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150206,'岭北镇','524338','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150207,'建新镇','524345','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150208,'城月镇','524348','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150209,'乌塘镇','524357','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150210,'北坡镇','524359','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150211,'港门镇','524364','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150212,'河头镇','524369','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150213,'乐民镇','524373','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150214,'江洪镇','524376','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150215,'草潭镇','524379','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150216,'下录镇','524382','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150217,'杨柑镇','524386','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150218,'北潭镇','524389','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150219,'界炮镇','524391','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150220,'洋青镇','524394','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150221,'沙古镇','524396','遂溪县','广东','n');
INSERT INTO ZipCode VALUES (    150222,'丹竹塘、大垌村','524400','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150223,'廉江市','524400','广东','广东','y');
INSERT INTO ZipCode VALUES (    150224,'石城镇','524400','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150225,'县城(廉城镇','524400','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150226,'良垌镇','524431','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150227,'那梭村','524431','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150228,'平坦镇','524432','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150229,'新华镇','524433','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150230,'新民镇','524441','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150231,'龙湾镇','524442','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150232,'横山镇','524443','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150233,'安铺镇','524444','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150234,'草港、大山、黎头沙、新围','524444','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150235,'仔、云峡、北堤村','524444','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150236,'营仔镇','524446','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150237,'车板镇','524447','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150238,'高桥乡','524448','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150239,'青平镇','524449','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150240,'雅塘镇','524455','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150241,'石岭镇','524456','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150242,'石颈镇','524457','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150243,'长山镇','524458','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150244,'塘蓬镇','524459','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150245,'和寮镇','524461','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150246,'石角镇','524462','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150247,'河唇镇','524469','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150248,'吉水镇','524471','廉江市','广东','n');
INSERT INTO ZipCode VALUES (    150249,'大山江乡','524500','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150250,'郭屋、低垌、三江、水口渡','524500','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150251,'湖塘、奇艳村','524500','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150252,'龙塘村','524500','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150253,'吴川市','524500','广东','广东','y');
INSERT INTO ZipCode VALUES (    150254,'县城(梅录镇)','524500','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150255,'肖山村','524500','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150256,'长岐镇','524531','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150257,'下村、三浪、五和、南巢村','524531','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150258,'浅水镇','524533','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150259,'兰石镇','524541','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150260,'覃巴镇','524543','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150261,'王村港镇','524545','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150262,'博铺镇','524552','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150263,'塘尾镇','524557','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150264,'吴阳镇','524559','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150265,'黄坡镇','524563','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150266,'中山镇','524565','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150267,'塘多镇','524568','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150268,'板桥镇','524571','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150269,'振文镇','524573','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150270,'樟铺镇','524575','吴川市','广东','n');
INSERT INTO ZipCode VALUES (    150271,'宾西横街','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150272,'春苑1-2街','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150273,'春苑直街','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150274,'大岭仔','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150275,'大塘','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150276,'低埒','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150277,'东星路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150278,'高凉北路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150279,'高凉路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150280,'高凉南路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150281,'高山镇','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150282,'官渡路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150283,'官山东路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150284,'官山路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150285,'官山西路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150286,'光华北路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150287,'光华路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150288,'黄竹','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150289,'健康路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150290,'江东北路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150291,'江东南路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150292,'黎和东路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150293,'黎和路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150294,'黎和西路','525000','茂名市','广东','n');
INSERT INTO ZipCode VALUES (    150295,'茂名市','525000','广东','广东','y');

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -