MySQL版中国省市区数据表

MySQL版中国省市区数据表

web开发中经常会用到国内省市区的数据表信息，下面是作者从网上下载的一个MySQL版本的数据表，做了一下整理，发布出来与大家分享一下，也方便以后使用。

CREATE TABLE IF NOT EXISTS `db_yhm_city` (
  `id` int(2) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `pid` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*省/市数据信息*/
insert into `db_yhm_city` values(1,'北京',0);
insert into `db_yhm_city` values(2,'天津',0);
insert into `db_yhm_city` values(3,'上海',0);
insert into `db_yhm_city` values(4,'重庆',0);
insert into `db_yhm_city` values(5,'河北',0);
insert into `db_yhm_city` values(6,'山西',0);
insert into `db_yhm_city` values(7,'台湾',0);
insert into `db_yhm_city` values(8,'辽宁',0);
insert into `db_yhm_city` values(9,'吉林',0);
insert into `db_yhm_city` values(10,'黑龙江',0);
insert into `db_yhm_city` values(11,'江苏',0);
insert into `db_yhm_city` values(12,'浙江',0);
insert into `db_yhm_city` values(13,'安徽',0);
insert into `db_yhm_city` values(14,'福建',0);
insert into `db_yhm_city` values(15,'江西',0);
insert into `db_yhm_city` values(16,'山东',0);
insert into `db_yhm_city` values(17,'河南',0);
insert into `db_yhm_city` values(18,'湖北',0);
insert into `db_yhm_city` values(19,'湖南',0);
insert into `db_yhm_city` values(20,'广东',0);
insert into `db_yhm_city` values(21,'甘肃',0);
insert into `db_yhm_city` values(22,'四川',0);
insert into `db_yhm_city` values(24,'贵州',0);
insert into `db_yhm_city` values(25,'海南',0);
insert into `db_yhm_city` values(26,'云南',0);
insert into `db_yhm_city` values(27,'青海',0);
insert into `db_yhm_city` values(28,'陕西',0);
insert into `db_yhm_city` values(29,'广西',0);
insert into `db_yhm_city` values(30,'西藏',0);
insert into `db_yhm_city` values(31,'宁夏',0);
insert into `db_yhm_city` values(32,'新疆',0);
insert into `db_yhm_city` values(33,'内蒙古',0);
insert into `db_yhm_city` values(34,'澳门',0);
insert into `db_yhm_city` values(35,'香港',0);
/*市/区数据信息www.phpernote.com*/
insert into `db_yhm_city` values(NULL,'北京',1);
insert into `db_yhm_city` values(NULL,'天津',2);
insert into `db_yhm_city` values(NULL,'上海',3);
insert into `db_yhm_city` values(NULL,'重庆',4);
insert into `db_yhm_city` values(NULL,'石家庄',5);
insert into `db_yhm_city` values(NULL,'唐山',5);
insert into `db_yhm_city` values(NULL,'秦皇岛',5);
insert into `db_yhm_city` values(NULL,'邯郸',5);
insert into `db_yhm_city` values(NULL,'邢台',5);
insert into `db_yhm_city` values(NULL,'保定',5);
insert into `db_yhm_city` values(NULL,'张家口',5);
insert into `db_yhm_city` values(NULL,'承德',5);
insert into `db_yhm_city` values(NULL,'沧州',5);
insert into `db_yhm_city` values(NULL,'廊坊',5);
insert into `db_yhm_city` values(NULL,'衡水',5);
insert into `db_yhm_city` values(NULL,'太原',6);
insert into `db_yhm_city` values(NULL,'大同',6);
insert into `db_yhm_city` values(NULL,'阳泉',6);
insert into `db_yhm_city` values(NULL,'长治',6);
insert into `db_yhm_city` values(NULL,'晋城',6);
insert into `db_yhm_city` values(NULL,'朔州',6);
insert into `db_yhm_city` values(NULL,'晋中',6);
insert into `db_yhm_city` values(NULL,'运城',6);
insert into `db_yhm_city` values(NULL,'忻州',6);
insert into `db_yhm_city` values(NULL,'临汾',6);
insert into `db_yhm_city` values(NULL,'吕梁',6);
insert into `db_yhm_city` values(NULL,'台北',7);
insert into `db_yhm_city` values(NULL,'高雄',7);
insert into `db_yhm_city` values(NULL,'基隆',7);
insert into `db_yhm_city` values(NULL,'台中',7);
insert into `db_yhm_city` values(NULL,'台南',7);
insert into `db_yhm_city` values(NULL,'新竹',7);
insert into `db_yhm_city` values(NULL,'嘉义',7);
insert into `db_yhm_city` values(NULL,'台北',7);
insert into `db_yhm_city` values(NULL,'宜兰',7);
insert into `db_yhm_city` values(NULL,'桃园',7);
insert into `db_yhm_city` values(NULL,'新竹',7);
insert into `db_yhm_city` values(NULL,'苗栗',7);
insert into `db_yhm_city` values(NULL,'台中',7);
insert into `db_yhm_city` values(NULL,'彰化',7);
insert into `db_yhm_city` values(NULL,'南投',7);
insert into `db_yhm_city` values(NULL,'云林',7);
insert into `db_yhm_city` values(NULL,'嘉义',7);
insert into `db_yhm_city` values(NULL,'台南',7);
insert into `db_yhm_city` values(NULL,'高雄',7);
insert into `db_yhm_city` values(NULL,'屏东',7);
insert into `db_yhm_city` values(NULL,'澎湖',7);
insert into `db_yhm_city` values(NULL,'台东',7);
insert into `db_yhm_city` values(NULL,'花莲',7);
insert into `db_yhm_city` values(NULL,'沈阳',8);
insert into `db_yhm_city` values(NULL,'大连',8);
insert into `db_yhm_city` values(NULL,'鞍山',8);
insert into `db_yhm_city` values(NULL,'抚顺',8);
insert into `db_yhm_city` values(NULL,'本溪',8);
insert into `db_yhm_city` values(NULL,'丹东',8);
insert into `db_yhm_city` values(NULL,'锦州',8);
insert into `db_yhm_city` values(NULL,'营口',8);
insert into `db_yhm_city` values(NULL,'阜新',8);
insert into `db_yhm_city` values(NULL,'辽阳',8);
insert into `db_yhm_city` values(NULL,'盘锦',8);
insert into `db_yhm_city` values(NULL,'铁岭',8);
insert into `db_yhm_city` values(NULL,'朝阳',8);
insert into `db_yhm_city` values(NULL,'葫芦岛',8);
insert into `db_yhm_city` values(NULL,'长春',9);
insert into `db_yhm_city` values(NULL,'吉林',9);
insert into `db_yhm_city` values(NULL,'四平',9);
insert into `db_yhm_city` values(NULL,'辽源',9);
insert into `db_yhm_city` values(NULL,'通化',9);
insert into `db_yhm_city` values(NULL,'白山',9);
insert into `db_yhm_city` values(NULL,'松原',9);
insert into `db_yhm_city` values(NULL,'白城',9);
insert into `db_yhm_city` values(NULL,'延边',9);
insert into `db_yhm_city` values(NULL,'哈尔滨',10);
insert into `db_yhm_city` values(NULL,'齐齐哈尔',10);
insert into `db_yhm_city` values(NULL,'鹤岗',10);
insert into `db_yhm_city` values(NULL,'双鸭山',10);
insert into `db_yhm_city` values(NULL,'鸡西',10);
insert into `db_yhm_city` values(NULL,'大庆',10);
insert into `db_yhm_city` values(NULL,'伊春',10);
insert into `db_yhm_city` values(NULL,'牡丹江',10);
insert into `db_yhm_city` values(NULL,'佳木斯',10);
insert into `db_yhm_city` values(NULL,'七台河',10);
insert into `db_yhm_city` values(NULL,'黑河',10);
insert into `db_yhm_city` values(NULL,'绥化',10);
insert into `db_yhm_city` values(NULL,'大兴安岭',10);
insert into `db_yhm_city` values(NULL,'南京',11);
insert into `db_yhm_city` values(NULL,'无锡',11);
insert into `db_yhm_city` values(NULL,'徐州',11);
insert into `db_yhm_city` values(NULL,'常州',11);
insert into `db_yhm_city` values(NULL,'苏州',11);
insert into `db_yhm_city` values(NULL,'南通',11);
insert into `db_yhm_city` values(NULL,'连云港',11);
insert into `db_yhm_city` values(NULL,'淮安',11);
insert into `db_yhm_city` values(NULL,'盐城',11);
insert into `db_yhm_city` values(NULL,'扬州',11);
insert into `db_yhm_city` values(NULL,'镇江',11);
insert into `db_yhm_city` values(NULL,'泰州',11);
insert into `db_yhm_city` values(NULL,'宿迁',11);
insert into `db_yhm_city` values(NULL,'杭州',12);
insert into `db_yhm_city` values(NULL,'宁波',12);
insert into `db_yhm_city` values(NULL,'温州',12);
insert into `db_yhm_city` values(NULL,'嘉兴',12);
insert into `db_yhm_city` values(NULL,'湖州',12);
insert into `db_yhm_city` values(NULL,'绍兴',12);
insert into `db_yhm_city` values(NULL,'金华',12);
insert into `db_yhm_city` values(NULL,'衢州',12);
insert into `db_yhm_city` values(NULL,'舟山',12);
insert into `db_yhm_city` values(NULL,'台州',12);
insert into `db_yhm_city` values(NULL,'丽水',12);
insert into `db_yhm_city` values(NULL,'合肥',13);
insert into `db_yhm_city` values(NULL,'芜湖',13);
insert into `db_yhm_city` values(NULL,'蚌埠',13);
insert into `db_yhm_city` values(NULL,'淮南',13);
insert into `db_yhm_city` values(NULL,'马鞍山',13);
insert into `db_yhm_city` values(NULL,'淮北',13);
insert into `db_yhm_city` values(NULL,'铜陵',13);
insert into `db_yhm_city` values(NULL,'安庆',13);
insert into `db_yhm_city` values(NULL,'黄山',13);
insert into `db_yhm_city` values(NULL,'滁州',13);
insert into `db_yhm_city` values(NULL,'阜阳',13);
insert into `db_yhm_city` values(NULL,'宿州',13);
insert into `db_yhm_city` values(NULL,'巢湖',13);
insert into `db_yhm_city` values(NULL,'六安',13);
insert into `db_yhm_city` values(NULL,'亳州',13);
insert into `db_yhm_city` values(NULL,'池州',13);
insert into `db_yhm_city` values(NULL,'宣城',13);
insert into `db_yhm_city` values(NULL,'福州',14);
insert into `db_yhm_city` values(NULL,'厦门',14);
insert into `db_yhm_city` values(NULL,'莆田',14);
insert into `db_yhm_city` values(NULL,'三明',14);
insert into `db_yhm_city` values(NULL,'泉州',14);
insert into `db_yhm_city` values(NULL,'漳州',14);
insert into `db_yhm_city` values(NULL,'南平',14);
insert into `db_yhm_city` values(NULL,'龙岩',14);
insert into `db_yhm_city` values(NULL,'宁德',14);
insert into `db_yhm_city` values(NULL,'南昌',15);
insert into `db_yhm_city` values(NULL,'景德镇',15);
insert into `db_yhm_city` values(NULL,'萍乡',15);
insert into `db_yhm_city` values(NULL,'九江',15);
insert into `db_yhm_city` values(NULL,'新余',15);
insert into `db_yhm_city` values(NULL,'鹰潭',15);
insert into `db_yhm_city` values(NULL,'赣州',15);
insert into `db_yhm_city` values(NULL,'吉安',15);
insert into `db_yhm_city` values(NULL,'宜春',15);
insert into `db_yhm_city` values(NULL,'抚州',15);
insert into `db_yhm_city` values(NULL,'上饶',15);
insert into `db_yhm_city` values(NULL,'济南',16);
insert into `db_yhm_city` values(NULL,'青岛',16);
insert into `db_yhm_city` values(NULL,'淄博',16);
insert into `db_yhm_city` values(NULL,'枣庄',16);
insert into `db_yhm_city` values(NULL,'东营',16);
insert into `db_yhm_city` values(NULL,'烟台',16);
insert into `db_yhm_city` values(NULL,'潍坊',16);
insert into `db_yhm_city` values(NULL,'济宁',16);
insert into `db_yhm_city` values(NULL,'泰安',16);
insert into `db_yhm_city` values(NULL,'威海',16);
insert into `db_yhm_city` values(NULL,'日照',16);
insert into `db_yhm_city` values(NULL,'莱芜',16);
insert into `db_yhm_city` values(NULL,'临沂',16);
insert into `db_yhm_city` values(NULL,'德州',16);
insert into `db_yhm_city` values(NULL,'聊城',16);
insert into `db_yhm_city` values(NULL,'滨州',16);
insert into `db_yhm_city` values(NULL,'菏泽',16);
insert into `db_yhm_city` values(NULL,'郑州',17);
insert into `db_yhm_city` values(NULL,'开封',17);
insert into `db_yhm_city` values(NULL,'洛阳',17);
insert into `db_yhm_city` values(NULL,'平顶山',17);
insert into `db_yhm_city` values(NULL,'安阳',17);
insert into `db_yhm_city` values(NULL,'鹤壁',17);
insert into `db_yhm_city` values(NULL,'新乡',17);
insert into `db_yhm_city` values(NULL,'焦作',17);
insert into `db_yhm_city` values(NULL,'濮阳',17);
insert into `db_yhm_city` values(NULL,'许昌',17);
insert into `db_yhm_city` values(NULL,'漯河',17);
insert into `db_yhm_city` values(NULL,'三门峡',17);
insert into `db_yhm_city` values(NULL,'南阳',17);
insert into `db_yhm_city` values(NULL,'商丘',17);
insert into `db_yhm_city` values(NULL,'信阳',17);
insert into `db_yhm_city` values(NULL,'周口',17);
insert into `db_yhm_city` values(NULL,'驻马店',17);
insert into `db_yhm_city` values(NULL,'济源',17);
insert into `db_yhm_city` values(NULL,'武汉',18);
insert into `db_yhm_city` values(NULL,'黄石',18);
insert into `db_yhm_city` values(NULL,'十堰',18);
insert into `db_yhm_city` values(NULL,'荆州',18);
insert into `db_yhm_city` values(NULL,'宜昌',18);
insert into `db_yhm_city` values(NULL,'襄樊',18);
insert into `db_yhm_city` values(NULL,'鄂州',18);
insert into `db_yhm_city` values(NULL,'荆门',18);
insert into `db_yhm_city` values(NULL,'孝感',18);
insert into `db_yhm_city` values(NULL,'黄冈',18);
insert into `db_yhm_city` values(NULL,'咸宁',18);
insert into `db_yhm_city` values(NULL,'随州',18);
insert into `db_yhm_city` values(NULL,'仙桃',18);
insert into `db_yhm_city` values(NULL,'天门',18);
insert into `db_yhm_city` values(NULL,'潜江',18);
insert into `db_yhm_city` values(NULL,'神农架',18);
insert into `db_yhm_city` values(NULL,'恩施',18);
insert into `db_yhm_city` values(NULL,'长沙',19);
insert into `db_yhm_city` values(NULL,'株洲',19);
insert into `db_yhm_city` values(NULL,'湘潭',19);
insert into `db_yhm_city` values(NULL,'衡阳',19);
insert into `db_yhm_city` values(NULL,'邵阳',19);
insert into `db_yhm_city` values(NULL,'岳阳',19);
insert into `db_yhm_city` values(NULL,'常德',19);
insert into `db_yhm_city` values(NULL,'张家界',19);
insert into `db_yhm_city` values(NULL,'益阳',19);
insert into `db_yhm_city` values(NULL,'郴州',19);
insert into `db_yhm_city` values(NULL,'永州',19);
insert into `db_yhm_city` values(NULL,'怀化',19);
insert into `db_yhm_city` values(NULL,'娄底',19);
insert into `db_yhm_city` values(NULL,'湘西',19);
insert into `db_yhm_city` values(NULL,'广州',20);
insert into `db_yhm_city` values(NULL,'深圳',20);
insert into `db_yhm_city` values(NULL,'珠海',20);
insert into `db_yhm_city` values(NULL,'汕头',20);
insert into `db_yhm_city` values(NULL,'韶关',20);
insert into `db_yhm_city` values(NULL,'佛山',20);
insert into `db_yhm_city` values(NULL,'江门',20);
insert into `db_yhm_city` values(NULL,'湛江',20);
insert into `db_yhm_city` values(NULL,'茂名',20);
insert into `db_yhm_city` values(NULL,'肇庆',20);
insert into `db_yhm_city` values(NULL,'惠州',20);
insert into `db_yhm_city` values(NULL,'梅州',20);
insert into `db_yhm_city` values(NULL,'汕尾',20);
insert into `db_yhm_city` values(NULL,'河源',20);
insert into `db_yhm_city` values(NULL,'阳江',20);
insert into `db_yhm_city` values(NULL,'清远',20);
insert into `db_yhm_city` values(NULL,'东莞',20);
insert into `db_yhm_city` values(NULL,'中山',20);
insert into `db_yhm_city` values(NULL,'潮州',20);
insert into `db_yhm_city` values(NULL,'揭阳',20);
insert into `db_yhm_city` values(NULL,'云浮',20);
insert into `db_yhm_city` values(NULL,'兰州',21);
insert into `db_yhm_city` values(NULL,'金昌',21);
insert into `db_yhm_city` values(NULL,'白银',21);
insert into `db_yhm_city` values(NULL,'天水',21);
insert into `db_yhm_city` values(NULL,'嘉峪关',21);
insert into `db_yhm_city` values(NULL,'武威',21);
insert into `db_yhm_city` values(NULL,'张掖',21);
insert into `db_yhm_city` values(NULL,'平凉',21);
insert into `db_yhm_city` values(NULL,'酒泉',21);
insert into `db_yhm_city` values(NULL,'庆阳',21);
insert into `db_yhm_city` values(NULL,'定西',21);
insert into `db_yhm_city` values(NULL,'陇南',21);
insert into `db_yhm_city` values(NULL,'临夏',21);
insert into `db_yhm_city` values(NULL,'甘南',21);
insert into `db_yhm_city` values(NULL,'成都',22);
insert into `db_yhm_city` values(NULL,'自贡',22);
insert into `db_yhm_city` values(NULL,'攀枝花',22);
insert into `db_yhm_city` values(NULL,'泸州',22);
insert into `db_yhm_city` values(NULL,'德阳',22);
insert into `db_yhm_city` values(NULL,'绵阳',22);
insert into `db_yhm_city` values(NULL,'广元',22);
insert into `db_yhm_city` values(NULL,'遂宁',22);
insert into `db_yhm_city` values(NULL,'内江',22);
insert into `db_yhm_city` values(NULL,'乐山',22);
insert into `db_yhm_city` values(NULL,'南充',22);
insert into `db_yhm_city` values(NULL,'眉山',22);
insert into `db_yhm_city` values(NULL,'宜宾',22);
insert into `db_yhm_city` values(NULL,'广安',22);
insert into `db_yhm_city` values(NULL,'达州',22);
insert into `db_yhm_city` values(NULL,'雅安',22);
insert into `db_yhm_city` values(NULL,'巴中',22);
insert into `db_yhm_city` values(NULL,'资阳',22);
insert into `db_yhm_city` values(NULL,'阿坝',22);
insert into `db_yhm_city` values(NULL,'甘孜',22);
insert into `db_yhm_city` values(NULL,'凉山',22);
insert into `db_yhm_city` values(NULL,'贵阳',24);
insert into `db_yhm_city` values(NULL,'六盘水',24);
insert into `db_yhm_city` values(NULL,'遵义',24);
insert into `db_yhm_city` values(NULL,'安顺',24);
insert into `db_yhm_city` values(NULL,'铜仁',24);
insert into `db_yhm_city` values(NULL,'毕节',24);
insert into `db_yhm_city` values(NULL,'黔西南',24);
insert into `db_yhm_city` values(NULL,'黔东南',24);
insert into `db_yhm_city` values(NULL,'黔南',24);
insert into `db_yhm_city` values(NULL,'海口',25);
insert into `db_yhm_city` values(NULL,'三亚',25);
insert into `db_yhm_city` values(NULL,'五指山',25);
insert into `db_yhm_city` values(NULL,'琼海',25);
insert into `db_yhm_city` values(NULL,'儋州',25);
insert into `db_yhm_city` values(NULL,'文昌',25);
insert into `db_yhm_city` values(NULL,'万宁',25);
insert into `db_yhm_city` values(NULL,'东方',25);
insert into `db_yhm_city` values(NULL,'澄迈',25);
insert into `db_yhm_city` values(NULL,'定安',25);
insert into `db_yhm_city` values(NULL,'屯昌',25);
insert into `db_yhm_city` values(NULL,'临高',25);
insert into `db_yhm_city` values(NULL,'白沙',25);
insert into `db_yhm_city` values(NULL,'昌江',25);
insert into `db_yhm_city` values(NULL,'乐东',25);
insert into `db_yhm_city` values(NULL,'陵水',25);
insert into `db_yhm_city` values(NULL,'保亭',25);
insert into `db_yhm_city` values(NULL,'琼中',25);
insert into `db_yhm_city` values(NULL,'昆明',26);
insert into `db_yhm_city` values(NULL,'曲靖',26);
insert into `db_yhm_city` values(NULL,'玉溪',26);
insert into `db_yhm_city` values(NULL,'保山',26);
insert into `db_yhm_city` values(NULL,'昭通',26);
insert into `db_yhm_city` values(NULL,'丽江',26);
insert into `db_yhm_city` values(NULL,'思茅',26);
insert into `db_yhm_city` values(NULL,'临沧',26);
insert into `db_yhm_city` values(NULL,'文山',26);
insert into `db_yhm_city` values(NULL,'红河',26);
insert into `db_yhm_city` values(NULL,'西双版纳',26);
insert into `db_yhm_city` values(NULL,'楚雄',26);
insert into `db_yhm_city` values(NULL,'大理',26);
insert into `db_yhm_city` values(NULL,'德宏',26);
insert into `db_yhm_city` values(NULL,'怒江',26);
insert into `db_yhm_city` values(NULL,'迪庆',26);
insert into `db_yhm_city` values(NULL,'西宁',27);
insert into `db_yhm_city` values(NULL,'海东',27);
insert into `db_yhm_city` values(NULL,'海北',27);
insert into `db_yhm_city` values(NULL,'黄南',27);
insert into `db_yhm_city` values(NULL,'海南',27);
insert into `db_yhm_city` values(NULL,'果洛',27);
insert into `db_yhm_city` values(NULL,'玉树',27);
insert into `db_yhm_city` values(NULL,'海西',27);
insert into `db_yhm_city` values(NULL,'西安',28);
insert into `db_yhm_city` values(NULL,'铜川',28);
insert into `db_yhm_city` values(NULL,'宝鸡',28);
insert into `db_yhm_city` values(NULL,'咸阳',28);
insert into `db_yhm_city` values(NULL,'渭南',28);
insert into `db_yhm_city` values(NULL,'延安',28);
insert into `db_yhm_city` values(NULL,'汉中',28);
insert into `db_yhm_city` values(NULL,'榆林',28);
insert into `db_yhm_city` values(NULL,'安康',28);
insert into `db_yhm_city` values(NULL,'商洛',28);
insert into `db_yhm_city` values(NULL,'南宁',29);
insert into `db_yhm_city` values(NULL,'柳州',29);
insert into `db_yhm_city` values(NULL,'桂林',29);
insert into `db_yhm_city` values(NULL,'北海',29);
insert into `db_yhm_city` values(NULL,'防城港',29);
insert into `db_yhm_city` values(NULL,'钦州',29);
insert into `db_yhm_city` values(NULL,'贵港',29);
insert into `db_yhm_city` values(NULL,'玉林',29);
insert into `db_yhm_city` values(NULL,'百色',29);
insert into `db_yhm_city` values(NULL,'贺州',29);
insert into `db_yhm_city` values(NULL,'河池',29);
insert into `db_yhm_city` values(NULL,'来宾',29);
insert into `db_yhm_city` values(NULL,'崇左',29);
insert into `db_yhm_city` values(NULL,'拉萨',30);
insert into `db_yhm_city` values(NULL,'那曲',30);
insert into `db_yhm_city` values(NULL,'昌都',30);
insert into `db_yhm_city` values(NULL,'山南',30);
insert into `db_yhm_city` values(NULL,'日喀则',30);
insert into `db_yhm_city` values(NULL,'阿里',30);
insert into `db_yhm_city` values(NULL,'林芝',30);
insert into `db_yhm_city` values(NULL,'银川',31);
insert into `db_yhm_city` values(NULL,'石嘴山',31);
insert into `db_yhm_city` values(NULL,'吴忠',31);
insert into `db_yhm_city` values(NULL,'固原',31);
insert into `db_yhm_city` values(NULL,'中卫',31);
insert into `db_yhm_city` values(NULL,'乌鲁木齐',32);
insert into `db_yhm_city` values(NULL,'克拉玛依',32);
insert into `db_yhm_city` values(NULL,'石河子　',32);
insert into `db_yhm_city` values(NULL,'阿拉尔',32);
insert into `db_yhm_city` values(NULL,'图木舒克',32);
insert into `db_yhm_city` values(NULL,'五家渠',32);
insert into `db_yhm_city` values(NULL,'吐鲁番',32);
insert into `db_yhm_city` values(NULL,'阿克苏',32);
insert into `db_yhm_city` values(NULL,'喀什',32);
insert into `db_yhm_city` values(NULL,'哈密',32);
insert into `db_yhm_city` values(NULL,'和田',32);
insert into `db_yhm_city` values(NULL,'阿图什',32);
insert into `db_yhm_city` values(NULL,'库尔勒',32);
insert into `db_yhm_city` values(NULL,'昌吉　',32);
insert into `db_yhm_city` values(NULL,'阜康',32);
insert into `db_yhm_city` values(NULL,'米泉',32);
insert into `db_yhm_city` values(NULL,'博乐',32);
insert into `db_yhm_city` values(NULL,'伊宁',32);
insert into `db_yhm_city` values(NULL,'奎屯',32);
insert into `db_yhm_city` values(NULL,'塔城',32);
insert into `db_yhm_city` values(NULL,'乌苏',32);
insert into `db_yhm_city` values(NULL,'阿勒泰',32);
insert into `db_yhm_city` values(NULL,'呼和浩特',33);
insert into `db_yhm_city` values(NULL,'包头',33);
insert into `db_yhm_city` values(NULL,'乌海',33);
insert into `db_yhm_city` values(NULL,'赤峰',33);
insert into `db_yhm_city` values(NULL,'通辽',33);
insert into `db_yhm_city` values(NULL,'鄂尔多斯',33);
insert into `db_yhm_city` values(NULL,'呼伦贝尔',33);
insert into `db_yhm_city` values(NULL,'巴彦淖尔',33);
insert into `db_yhm_city` values(NULL,'乌兰察布',33);
insert into `db_yhm_city` values(NULL,'锡林郭勒盟',33);
insert into `db_yhm_city` values(NULL,'兴安盟',33);
insert into `db_yhm_city` values(NULL,'阿拉善盟',33);
insert into `db_yhm_city` values(NULL,'澳门',34);
insert into `db_yhm_city` values(NULL,'香港',35);

您可能感兴趣的文章

• PHP压缩html网页代码减小网络数据传输量,清除空格,制表符,注释标记
• mysql如何导出表中的某个字段的数据
• MySQL各种数据表类型重设自增起始值的方法
• jquery设置按钮不可点击防止重复提交数据
• 针对MySQL提高百万条数据的查询速度优化
• mysql查询今天,昨天,近7天,近30天,本月,上一月数据的方法
• 在php中分别使用curl的post提交数据的方法和get获取网页数据的方法总结
• MySQL replace函数替换字符串语句的用法