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

📄 zipcodeinsert04.sql

📁 全国邮政编码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
--邮政编码数据(150001-187287行)
INSERT INTO ZipCode VALUES (    150001,'民族路','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150002,'木桥街','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150003,'染房街','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150004,'胜利路','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150005,'水仙街','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150006,'幸福横路','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150007,'幸福路','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150008,'永宁路','524034','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150009,'博爱路','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150010,'潮州街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150011,'大通街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150012,'东方街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150013,'福建横巷','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150014,'福建街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150015,'高州街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150016,'关庙街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150017,'花园街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150018,'井街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150019,'九二一路','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150020,'九二一路五横','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150021,'力行街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150022,'米行横巷','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150023,'米行街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150024,'南京1-3横路','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150025,'南京路','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150026,'南兴街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150027,'泥水街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150028,'平安街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150029,'荣光里','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150030,'三和街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150031,'泰安街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150032,'图强街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150033,'团结横巷','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150034,'团结街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150035,'新风街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150036,'新民横巷','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150037,'新民街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150038,'新生1-3巷','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150039,'新生街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150040,'盐埠街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150041,'永安街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150042,'娱乐路','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150043,'中山二路','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150044,'中山二路南二巷','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150045,'中山二路南一巷','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150046,'中兴街','524035','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150047,'拥军1-3巷','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150048,'拥军路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150049,'劳动路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150050,'立新横','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150051,'立新路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150052,'为群路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150053,'新华1-2巷','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150054,'新华路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150055,'益民1-4横巷','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150056,'益民路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150057,'英勇1-2横路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150058,'英勇路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150059,'爱民1-2横巷','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150060,'爱民路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150061,'大德路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150062,'大德路1-2横','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150063,'光辉1-2横巷','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150064,'光辉路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150065,'和睦路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150066,'和睦路1-2横路','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150067,'九二一路1-4横','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150068,'劳动横巷','524036','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150069,'寸金1-5横路','524037','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150070,'寸金路','524037','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150071,'高田、文章村','524037','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150072,'农林1-2路','524037','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150073,'保健路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150074,'光复1-3巷','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150075,'光复路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150076,'荔枝园','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150077,'南方1-4巷','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150078,'南方路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150079,'太康横路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150080,'太康路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150081,'卫生路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150082,'文东路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150083,'新太路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150084,'兴国路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150085,'兴汉横巷','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150086,'兴汉路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150087,'兴华路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150088,'跃进1-2横','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150089,'跃进路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150090,'中华路','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150091,'中华路一横巷','524038','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150092,'北桥1-4横','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150093,'北桥路','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150094,'赤坎区','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150095,'东山、海萍村','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150096,'新春1-3巷','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150097,'新春路','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150098,'新景1-4巷','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150099,'新景村','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150100,'新景路','524039','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150101,'百姓村','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150102,'百姓路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150103,'百园路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150104,'陈屋港','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150105,'调顺路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150106,'东园路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150107,'海滨七路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150108,'海滨七路1-2横','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150109,'康顺路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150110,'南桥南路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150111,'南桥新村','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150112,'南桥新村1-5巷','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150113,'人民大道此','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150114,'湾北路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150115,'湾南路','524043','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150116,'海滨5-6路','524044','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150117,'龙潮、文保、沙湾村','524044','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150118,'龙潮路','524044','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150119,'平阳路','524044','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150120,'霞赤4-5路','524044','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150121,'北站路','524045','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150122,'草苏、陈铁、岑擎、后洋、','524045','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150123,'楼下、东纯、冯村村','524045','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150124,'官渡镇','524051','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150125,'龙头镇','524054','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150126,'坡头镇','524059','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150127,'乾塘镇','524061','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150128,'南三镇','524067','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150129,'巴东村','524069','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150130,'东简镇','524072','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150131,'硇州镇','524074','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150132,'东山镇','524076','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150133,'民安镇','524081','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150134,'太平镇','524084','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150135,'北月、调罗、木兰村','524088','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150136,'湖光镇','524088','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150137,'畅祝村','524091','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150138,'麻章镇','524094','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150139,'调顺岛','524099','湛江市','广东','n');
INSERT INTO ZipCode VALUES (    150140,'城北乡','524100','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150141,'城南乡','524100','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150142,'大黄乡','524100','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150143,'五里乡','524100','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150144,'县城(徐城镇','524100','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150145,'徐城镇','524100','徐闻县','广东','n');
INSERT INTO ZipCode VALUES (    150146,'徐闻县','524100','广东','广东','y');
INSERT INTO ZipCode VALUES (    150147,'成埚村','524131','徐闻县','广东','n');

⌨️ 快捷键说明

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