ecmall全国城市地区数据表

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

delete from `ecm_region`;
INSERT INTO `ecm_region` (`region_id`,`region_name`,`parent_id`,`sort_order`) VALUES
(2,'中国',255),(3,'北京市',2,(4,'东城',3,(5,'西城',(6,'崇文',(7,'宣武',(8,'朝阳',(9,'海淀',(10,'丰台',(11,'石景山',(12,'门头沟',(13,'房山',(14,'通州',(15,'顺义',(16,'大兴',(17,'昌平',(18,'平谷',(19,'怀柔',(20,'延庆',(21,'密云',(22,'天津市',(23,'和平区',22,(24,'河东区',(25,'河西区',(26,'南开区',(27,'河北区',(28,'红桥区',(29,'塘沽区',(30,'汉沽区',(31,'大港区',(32,'西青区',(33,'东丽区',(34,'津南区',(35,'北辰区',(36,'武清区',(37,'宝坻区',(38,'静海县',(39,'宁河县',(40,'蓟县',(41,'上海市',(42,'浦东新区',41,(43,'徐汇区',(44,'长宁区',(45,'普陀区',(46,'闸北区',(47,'虹口区',(48,'杨浦区',(49,'黄浦区',(50,'卢湾区',(51,'静安区',(52,'宝山区',(53,'闵行区',(54,'嘉定区',(55,'金山区',(56,'松江区',(57,'青浦区',(58,'崇明县',(59,'奉贤区',(60,'南汇区',(61,'重庆市',(62,'渝中',61,(63,'大渡口',(64,'江北',(65,'沙坪坝',(66,'九龙坡',(67,'南岸',(68,'北碚',(69,'渝北',(70,'巴南',(71,'北部新区',(72,'经开区',(73,'万盛',(74,'双桥',(75,'綦江',(76,'潼南',(77,'铜梁',(78,'大足',(79,'荣昌',(80,'璧山',(81,'江津',(82,'合川',(83,'永川',(84,'南川',(85,'万州',(86,'涪陵',(87,'黔江',(88,'长寿',(89,'梁平',(90,'城口',(91,'丰都',(92,'垫江',(93,'武隆',(94,'忠县',(95,'开县',(96,'云阳',(97,'奉节',(98,'巫山',(99,'巫溪',(100,'石柱',(101,'秀山',(102,'酉阳',(103,'彭水',(104,'河北省',(105,'石家庄',104,(106,'衡水',(107,'唐山',(108,'秦皇岛',(109,'张家口',(110,'承德',(111,'邯郸',(112,'沧州',(113,'邢台',(114,'保定',(115,'廊坊',(116,'山西省',(117,'太原市',116,(118,'大同市',(119,'朔州市',(120,'忻州市',(121,'长治市',(122,'阳泉市',(123,'晋中市',(124,'吕梁市',(125,'晋城市',(126,'临汾市',(127,'运城市',(128,'辽宁省',(129,'沈阳',128,(130,'大连',(131,'鞍山',(132,'抚顺',(133,'本溪',(134,'丹东',(135,'锦州',(136,'营口',(137,'阜新',(138,'辽阳',(139,'铁岭',(140,(141,'盘锦',(142,'葫芦岛',(143,'吉林省',(144,'长春市',143,(145,'吉林市',(146,'四平市',(147,'辽源市',(148,'通化市',(149,'白山市',(150,'松原市',(151,'白城市',(152,'延边州',(153,'黑龙江省',(154,'哈尔滨',153,(155,'齐齐哈尔',(156,'牡丹江',(157,'佳木斯',(158,'大庆',(159,'鸡西',(160,'伊春',(161,'双鸭山',(162,'七台河',(163,'鹤岗',(164,'黑河',(165,'绥化',(166,'大兴安岭',(167,'内蒙古自治区',(168,'呼和浩特市',167,(169,'包头市',(170,'乌海市',(171,'赤峰市',(172,'通辽市',(173,'鄂尔多斯市',(174,'呼伦贝尔市',(175,'巴彦淖尔市',(176,'乌兰察布市',(177,'锡林郭勒盟',(178,'兴安盟',(179,'阿拉善盟',(180,'江苏省',(181,'南京',180,(182,'苏州',(183,'无锡',(184,'常州',(185,'扬州',(186,'南通',(187,'镇江',(188,'泰州',(189,'淮安',(190,'徐州',(191,'盐城',(192,'宿迁',(193,'连云港',(194,'浙江省',(195,'杭州',194,(196,'宁波',(197,'温州',(198,'嘉兴',(199,'湖州',(200,'绍兴',(201,'金华',(202,'衢州',(203,'舟山',(204,'台州',(205,'丽水',(206,'安徽省',(207,'淮北市',206,(208,'合肥市',(209,'六安市',(210,'亳州市',(211,'宿州市',(212,'阜阳市',(213,'蚌埠市',(214,'淮南市',(215,'滁州市',(216,'巢湖市',(217,'芜湖市',(218,'马鞍山',(219,'安庆市',(220,'池州市',(221,'铜陵市',(222,'宣城市',(223,'黄山市',(224,'福建省',(225,'福州市',224,(226,'厦门市',(227,'莆田市',(228,'三明市',(229,'泉州市',(230,'漳州市',(231,'南平市',(232,'龙岩市',(233,'宁德市',(234,'江西省',(235,'南昌市',234,(236,'景德镇市',(237,'萍乡市',(238,'九江市',(239,'新余市',(240,'鹰潭市',(241,'赣州市',(242,'吉安市',(243,'宜春市',(244,'抚州市',(245,'上饶市',(246,'山东省',(247,'济南',246,(248,'青岛',(249,'淄博',(250,'泰安',(251,'济宁',(252,'德州',(253,'日照',(254,'潍坊',(255,'枣庄',(256,'临沂',(257,'莱芜',(258,'滨州',(259,'聊城',(260,'菏泽',(261,'烟台',(262,'威海',(263,'东营',(264,'河南省',(265,'郑州市',264,(266,'洛阳市',(267,'开封市',(268,'平顶山市',(269,'南阳市',(270,'焦作市',(271,'信阳市',(272,'济源市',(273,'周口市',(274,'安阳市',(275,'驻马店市',(276,'新乡市',(277,'鹤壁市',(278,'商丘市',(279,'漯河市',(280,'许昌市',(281,'三门峡市',(282,'濮阳市',(283,'湖北省',(284,'武汉',283,(285,'宜昌',(286,'荆州',(287,'十堰',(288,'襄樊',(289,'黄石',(290,'黄冈',(291,'恩施',(292,'荆门',(293,'咸宁',(294,'孝感',(295,'鄂州',(296,'天门',(297,'仙桃',(298,'随州',(299,'潜江',(300,'神农架',(301,'湖南省',(302,'长沙市',301,(303,'株洲市',(304,'湘潭市',(305,'邵阳市',(306,'吉首市',(307,'岳阳市',(308,'娄底市',(309,'怀化市',(310,'永州市',(311,'郴州市',(312,'常德市',(313,'衡阳市',(314,'益阳市',(315,'张家界',(316,'湘西州',(317,'广东省',(318,'广州',317,(319,'深圳',(320,'珠海',(321,'汕头',(322,'佛山',(323,'东莞',(324,'中山',(325,'江门',(326,'惠州',(327,'肇庆',(328,'阳江',(329,'韶关',(330,'河源',(331,'梅州',(332,'清远',(333,'云浮',(334,'茂名',(335,'汕尾',(336,'揭阳',(337,'潮州',(338,'湛江',(339,'海南省',(340,'海口市',339,(341,'三亚市',(342,'广西壮族自治区',(343,'南宁',342,(344,'柳州',(345,'桂林',(346,'梧州',(347,'北海',(348,'防城港',(349,'钦州',(350,'贵港',(351,'玉林',(352,'百色',(353,'贺州',(354,'河池',(355,'来宾',(356,'崇左',(357,'四川省',(358,'成都',357,(359,'自贡',(360,'攀枝花',(361,'泸州',(362,'德阳',(363,'绵阳',(364,'广元',(365,'遂宁',(366,'内江',(367,'资阳',(368,'乐山',(369,'眉山',(370,'南充',(371,'宜宾',(372,'广安',(373,'达州',(374,'巴中',(375,'雅安',(376,'阿坝',(377,'甘孜',(378,'凉山',(379,'贵州省',(380,'贵阳市',379,(381,'遵义市',(382,'安顺市',(383,'六盘水市',(384,'毕节地区',(385,'铜仁地区',(386,'黔东南州',(387,'黔南州',(388,'黔西南州',(389,'云南省',(390,'昆明市',389,(391,'曲靖市',(392,'红河哈尼族彝族自治州',(393,'昭通市',(394,'玉溪市',(395,'德宏傣族景颇族自治州',(396,'丽江市',(397,'迪庆藏族自治州',(398,'文山壮族苗族自治州',(399,'思茅市',(400,'大理白族自治州',(401,'怒江傈僳族自治州',(402,'保山市',(403,'楚雄彝族自治州',(404,'西双版纳傣族自治州',(405,'临沧市',(406,'西藏自治区',(407,'拉萨',406,(408,'日喀则',(409,'林芝',(410,'山南',(411,'那曲',(412,'昌都',(413,'阿里',(414,'陕西省',(415,'西安市',414,(416,'铜川市',(417,'宝鸡市',(418,'咸阳市',(419,'渭南市',(420,'延安市',(421,'汉中市',(422,'榆林市',(423,'安康市',(424,'商洛市',(425,'甘肃省',(426,'兰州市',425,(427,'嘉峪关',(428,'金昌市',(429,'白银市',(430,'天水市',(431,'酒泉市',(432,'张掖市',(433,'武威市',(434,'定西市',(435,'陇南市',(436,'平凉市',(437,'庆阳市',(438,'临夏州',(439,'甘南州',(440,'青海省',(441,'西宁市',440,(442,'海东行署',(443,'海北藏族自治州',(444,'海南藏族自治州',(445,'海西州',(446,'黄南藏族自治州',(447,'玉树藏族自治州',(448,'果洛藏族自治州',(449,'宁夏回族自治区',(450,'银川市',449,(451,'石嘴山市',(452,'吴忠市',(453,'固原市',(454,'中卫市',(455,'新疆维吾尔自治区',(456,'伊犁哈萨克自治州',455,(457,'乌鲁木齐市',(458,'昌吉回族自治州',(459,'石河子市',(460,'克拉玛依市',(461,'阿勒泰地区',(462,'博尔塔拉蒙古自治州',(463,'塔城地区',(464,'和田地区',(465,'克孜勒苏克尔克孜自治州',(466,'喀什地区',(467,'阿克苏地区',(468,'巴音郭楞蒙古自治州',(469,'吐鲁番地区',(470,'哈密地区',(471,'五家渠市',(472,'阿拉尔市',(473,'图木舒克市',(474,'香港特别行政区',(475,'澳门特别行政区',(476,'台湾省',255);

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!