中国城市数据库（SQL）

--邮政编码数据(1-50000行) INSERT INTO ZipCode VALUES ( 1,'金门县','000000','福建','福建','y'); INSERT INTO ZipCode VALUES ( 2,'铁路基','000940','宝山区','上海','n'); INSERT INTO ZipCode VALUES ( 3,'果子洼回族自治乡','006245','河间市','河北','n'); INSERT INTO ZipCode VALUES ( 4,'呼和浩特市','010000','内蒙古','内蒙古','y'); INSERT INTO ZipCode VALUES ( 5,'北牛肉铺巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 6,'北垣街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 7,'大台什路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 8,'大学东路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 9,'电杆厂街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 10,'东风路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 11,'东护城河路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 12,'东升街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 13,'东影北街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 14,'粮响府街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 15,'粮站南街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 16,'南门里后巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 17,'南门里前巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 18,'青城巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 19,'庆丰东街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 20,'庆丰街后巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 21,'庆丰街前巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 22,'庆丰西街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 23,'庆恒太巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 24,'东影南街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 25,'二眼井巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 26,'丰收巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 27,'付茶馆巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 28,'公义局巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 29,'关帝庙街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 30,'光华街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 31,'光荣巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 32,'和平北路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 33,'和平南路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 34,'红星西街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 35,'呼伦北路(铁道以南、路东)','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 36,'呼伦南路(乌兰察布西路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 37,'机场路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 38,'建设东街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 39,'建设东街小巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 40,'建设西街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 41,'巨隆昌北街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 42,'巨隆昌南街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 43,'利民街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 44,'日盛茂街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 45,'如意河、小厂 囵、沙梁','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 46,'十四中西巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 47,'市场后巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 48,'市场前巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 49,'书院西街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 50,'曙光街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 51,'曙光街二道巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 52,'曙光街三道巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 53,'曙光街头道巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 54,'水利街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 55,'水源街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 56,'乌兰察布东路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 57,'乌兰察布西路(北)','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 58,'西夹道巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 59,'小台村、大台村、桥靠村','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 60,'新城北街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 61,'新城东街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 62,'新城南街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 63,'新城西街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 64,'新建东街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 65,'星火巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 66,'兴安北路(铁道南)','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 67,'兴安南路','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 68,'幸福巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 69,'以北、路东)','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 70,'艺术厅北街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 71,'艺术厅南街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 72,'永胜巷','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 73,'昭乌达路(东)','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 74,'子、付号板、黑兰布塔村','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 75,'总局街','010010','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 76,'团结小区','010011','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 77,'(乌兰察布西路以南)','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 78,'(新华大街路口以南)','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 79,'贝尔路','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 80,'城建街','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 81,'大学西路','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 82,'公园东路','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 83,'公园南路','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 84,'公园西路(东)','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 85,'红色街','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 86,'红色路','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 87,'红色巷','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 88,'呼伦南路','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES ( 89,'呼伦南路(乌兰察布西路','010020','呼和浩特市','内蒙古','n'); INSERT INTO ZipCode VALUES (