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

📄 zipcodeinsert03.sql

📁 全国邮政编码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
--邮政编码数据(100001-150000行)
INSERT INTO ZipCode VALUES (    100001,'斗富一桥西河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100002,'豆腐弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100003,'断河头','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100004,'方福弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100005,'大河下新村','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100006,'大火把弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100007,'大茅衙弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100008,'大兴隆巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100009,'大学路','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100010,'大学路新村','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100011,'当铺弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100012,'道院巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100013,'东赶猪弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100014,'东牌楼','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100015,'长寿里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100016,'称心里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100017,'城头巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100018,'城站路','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100019,'城站马弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100020,'淳佑桥东弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100021,'淳佑桥西弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100022,'大东山弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100023,'大光坊弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100024,'大河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100025,'菜市弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100026,'菜市桥东河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100027,'柴木巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100028,'柴弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100029,'场官弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100030,'长乐里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100031,'长明寺巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100032,'长木桥、草庵、打铁关、三','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100033,'长坡里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100034,'长庆里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100035,'周叶闻弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100036,'竹弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100037,'竹椅子巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100038,'状元弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100039,'总管弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100040,'银钩弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100041,'佑圣观路','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100042,'余打枝巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100043,'章家桥河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100044,'直福元巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100045,'直骨牌弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100046,'直吉祥巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100047,'中羊线弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100048,'忠孝弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100049,'忠孝巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100050,'新宫桥河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100051,'信余里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100052,'玄坛弄(在断河头)','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100053,'靴儿河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100054,'严衙弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100055,'燕子弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100056,'杨衙弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100057,'姚园寺巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100058,'叶家弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100059,'义井巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100060,'下羊线弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100061,'下珠宝巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100062,'小城隍庙前','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100063,'小东山弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100064,'小光坊弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100065,'小河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100066,'小火把弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100067,'小茅衙弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100068,'小米巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100069,'肖家弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100070,'土桥西河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100071,'土桥新村','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100072,'瓦灰弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100073,'瓦子巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100074,'湾井弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100075,'万安桥东弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100076,'五福巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100077,'五柳巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100078,'西牌楼','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100079,'戏院弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100080,'双井弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100081,'水亭址','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100082,'水仙弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100083,'四维里1-2弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100084,'宿舟河下1-54号','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100085,'太昌里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100086,'铁佛寺桥河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100087,'土桥1-2弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100088,'土桥东河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100089,'土桥里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100090,'上羊线弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100091,'上珠宝巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100092,'沈衙弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100093,'师巫弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100094,'世守里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100095,'双104-520号','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100096,'双2-108号','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100097,'双2-90号','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100098,'双24-318号','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100099,'双636号-完','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100100,'庆春新村','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100101,'劝业里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100102,'仁智里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100103,'三昧庵巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100104,'三圣桥河下','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100105,'三益里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100106,'杀牛弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100107,'商山里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100108,'上刀茅巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100109,'上石板巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100110,'南花园弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100111,'凝海巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100112,'潘衙弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100113,'平阳里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100114,'栖霞里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100115,'青莲巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100116,'清泰街  单197-605号','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100117,'庆春里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100118,'庆春路  单37-219号','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100119,'庆春弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100120,'茅廊巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100121,'毛儿弄(在庆春路)','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100122,'毛家井','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100123,'毛竹弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100124,'梅花碑','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100125,'民权路','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100126,'民生路','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100127,'莫山房弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100128,'南班巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100129,'南班巷北弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100130,'老浙大横路','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100131,'老浙大横路1-3弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100132,'老浙大直路','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100133,'老浙大直路1-3弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100134,'里塘巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100135,'联珠里','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100136,'林木梳巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100137,'陆家河头','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100138,'马坡巷','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100139,'马子弄','310009','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100140,'安仁里','310011','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100141,'秉祥巷','310011','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100142,'长征桥路  单11号-完','310011','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100143,'打铁弄','310011','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100144,'戴陈弄','310011','杭州市','浙江','n');
INSERT INTO ZipCode VALUES (    100145,'董家弄','310011','杭州市','浙江','n');

⌨️ 快捷键说明

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