📄 zipcodeinsert04.sql
字号:
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 + -