全国省市数据库

省份

insert into province(code,name) values(1,'北京市');
insert into province(code,name) values(2,'天津市');
insert into province(code,name) values(3,'上海市');
insert into province(code,name) values(4,'重庆市');
insert into province(code,name) values(5,'河北省');
insert into province(code,name) values(6,'山西省');
insert into province(code,name) values(7,'台湾省');
insert into province(code,name) values(8,'辽宁省');
insert into province(code,name) values(9,'吉林省');
insert into province(code,name) values(10,'黑龙江省');
insert into province(code,name) values(11,'江苏省');
insert into province(code,name) values(12,'浙江省');
insert into province(code,name) values(13,'安徽省');
insert into province(code,name) values(14,'福建省');
insert into province(code,name) values(15,'江西省');
insert into province(code,name) values(16,'山东省');
insert into province(code,name) values(17,'河南省');
insert into province(code,name) values(18,'湖北省');
insert into province(code,name) values(19,'湖南省');
insert into province(code,name) values(20,'广东省');
insert into province(code,name) values(21,'甘肃省');
insert into province(code,name) values(22,'四川省');
insert into province(code,name) values(24,'贵州省');
insert into province(code,name) values(25,'海南省');
insert into province(code,name) values(26,'云南省');
insert into province(code,name) values(27,'青海省');
insert into province(code,name) values(28,'陕西省');
insert into province(code,name) values(29,'广西壮族自治区');
insert into province(code,name) values(30,'西藏自治区');
insert into province(code,name) values(31,'宁夏回族自治区');
insert into province(code,name) values(32,'新疆维吾尔自治区');
insert into province(code,name) values(33,'内蒙古自治区');
insert into province(code,name) values(34,'澳门特别行政区');
insert into province(code,name) values(35,'香港特别行政区');
市区

insert into city(code,name,province_code) values(1,'北京市',1);
insert into city(code,name,province_code) values(2,'天津市',2);
insert into city(code,name,province_code) values(3,'上海市',3);
insert into city(code,name,province_code) values(4,'重庆市',4);
--5河北省(2005年辖：11个地级市，36个市辖区、22个县级市、108个县、6个自治县)
insert into city(code,name,province_code) values(5,'石家庄市',5);
insert into city(code,name,province_code) values(6,'唐山市',5);
insert into city(code,name,province_code) values(7,'秦皇岛市',5);
insert into city(code,name,province_code) values(8,'邯郸市',5);
insert into city(code,name,province_code) values(9,'邢台市',5);
insert into city(code,name,province_code) values(10,'保定市',5);
insert into city(code,name,province_code) values(11,'张家口市',5);
insert into city(code,name,province_code) values(12,'承德市',5);
insert into city(code,name,province_code) values(13,'沧州市',5);
insert into city(code,name,province_code) values(14,'廊坊市',5);
insert into city(code,name,province_code) values(15,'衡水市',5);
--6山西省11个城市
insert into city(code,name,province_code) values(16,'太原市',6);
insert into city(code,name,province_code) values(17,'大同市',6);
insert into city(code,name,province_code) values(18,'阳泉市',6);
insert into city(code,name,province_code) values(19,'长治市',6);
insert into city(code,name,province_code) values(20,'晋城市',6);
insert into city(code,name,province_code) values(21,'朔州市',6);
insert into city(code,name,province_code) values(22,'晋中市',6);
insert into city(code,name,province_code) values(23,'运城市',6);
insert into city(code,name,province_code) values(24,'忻州市',6);
insert into city(code,name,province_code) values(25,'临汾市',6);
insert into city(code,name,province_code) values(26,'吕梁市',6);
--7台湾省(台湾本岛和澎湖共设7市、16县，其中台北市和高雄市为“院辖市”，直属“行政院”，其余属台湾省；市下设区，县下设市（县辖市）、镇、乡，合称区市镇乡。)
insert into city(code,name,province_code) values(27,'台北市',7);
insert into city(code,name,province_code) values(28,'高雄市',7);
insert into city(code,name,province_code) values(29,'基隆市',7);
insert into city(code,name,province_code) values(30,'台中市',7);
insert into city(code,name,province_code) values(31,'台南市',7);
insert into city(code,name,province_code) values(32,'新竹市',7);
insert into city(code,name,province_code) values(33,'嘉义市',7);
insert into city(code,name,province_code) values(34,'台北县',7);
insert into city(code,name,province_code) values(35,'宜兰县',7);
insert into city(code,name,province_code) values(36,'桃园县',7);
insert into city(code,name,province_code) values(37,'新竹县',7);
insert into city(code,name,province_code) values(38,'苗栗县',7);
insert into city(code,name,province_code) values(39,'台中县',7);
insert into city(code,name,province_code) values(40,'彰化县',7);
insert into city(code,name,province_code) values(41,'南投县',7);
insert into city(code,name,province_code) values(42,'云林县',7);
insert into city(code,name,province_code) values(43,'嘉义县',7);
insert into city(code,name,province_code) values(44,'台南县',7);
insert into city(code,name,province_code) values(45,'高雄县',7);
insert into city(code,name,province_code) values(46,'屏东县',7);
insert into city(code,name,province_code) values(47,'澎湖县',7);
insert into city(code,name,province_code) values(48,'台东县',7);
insert into city(code,name,province_code) values(49,'花莲县',7);
--8辽宁省(2006年，辖：14个地级市；56个市辖区、17个县级市、19个县、8个自治县。)
insert into city(code,name,province_code) values(50,'沈阳市',8);
insert into city(code,name,province_code) values(51,'大连市',8);
insert into city(code,name,province_code) values(52,'鞍山市',8);
insert into city(code,name,province_code) values(53,'抚顺市',8);
insert into city(code,name,province_code) values(54,'本溪市',8);
insert into city(code,name,province_code) values(55,'丹东市',8);
insert into city(code,name,province_code) values(56,'锦州市',8);
insert into city(code,name,province_code) values(57,'营口市',8);
insert into city(code,name,province_code) values(58,'阜新市',8);
insert into city(code,name,province_code) values(59,'辽阳市',8);
insert into city(code,name,province_code) values(60,'盘锦市',8);
insert into city(code,name,province_code) values(61,'铁岭市',8);
insert into city(code,name,province_code) values(62,'朝阳市',8);
insert into city(code,name,province_code) values(63,'葫芦岛市',8;)
--9吉林省(2006年，辖：8个地级市、1个自治州；20个市辖区、20个县级市、17个县、3个自治县。)
insert into city(code,name,province_code) values(64,'长春市',9);
insert into city(code,name,province_code) values(65,'吉林市',9);
insert into city(code,name,province_code) values(66,'四平市',9);
insert into city(code,name,province_code) values(67,'辽源市',9);
insert into city(code,name,province_code) values(68,'通化市',9);
insert into city(code,name,province_code) values(69,'白山市',9);
insert into city(code,name,province_code) values(70,'松原市',9);
insert into city(code,name,province_code) values(71,'白城市',9);
insert into city(code,name,province_code) values(72,'延边朝鲜族自治州',9);
--10黑龙江省(2006年，辖：12地级市、1地区；64市辖区、18县级市、45县、1自治县)
insert into city(code,name,province_code) values(73,'哈尔滨市',10);
insert into city(code,name,province_code) values(74,'齐齐哈尔市',10);
insert into city(code,name,province_code) values(75,'鹤 岗 市',10);
insert into city(code,name,province_code) values(76,'双鸭山市',10);
insert into city(code,name,province_code) values(77,'鸡 西 市',10);
insert into city(code,name,province_code) values(78,'大 庆 市',10);
insert into city(code,name,province_code) values(79,'伊 春 市',10);
insert into city(code,name,province_code) values(80,'牡丹江市',10);
insert into city(code,name,province_code) values(81,'佳木斯市',10);
insert into city(code,name,province_code) values(82,'七台河市',10);
insert into city(code,name,province_code) values(83,'黑 河 市',10);
insert into city(code,name,province_code) values(84,'绥 化 市',10);
insert into city(code,name,province_code) values(85,'大兴安岭地区',10);
--11江苏省(2005年辖：13个地级市；54个市辖区、27个县级市、25个县)
insert into city(code,name,province_code) values(86,'南京市',11);
insert into city(code,name,province_code) values(87,'无锡市',11);
insert into city(code,name,province_code) values(88,'徐州市',11);
insert into city(code,name,province_code) values(89,'常州市',11);
insert into city(code,name,province_code) values(90,'苏州市',11);
insert into city(code,name,province_code) values(91,'南通市',11);
insert into city(code,name,province_code) values(92,'连云港市',11);
insert into city(code,name,province_code) values(93,'淮安市',11);
insert into city(code,name,province_code) values(94,'盐城市',11);
insert into city(code,name,province_code) values(95,'扬州市',11);
insert into city(code,name,province_code) values(96,'镇江市',11);
insert into city(code,name,province_code) values(97,'泰州市',11);
insert into city(code,name,province_code) values(98,'宿迁市',11);
--12浙江省(2006年，辖：11个地级市；32个市辖区、22个县级市、35个县、1个自治县。)
insert into city(code,name,province_code) values(99,'杭州市',12);
insert into city(code,name,province_code) values(100,'宁波市',12);
insert into city(code,name,province_code) values(101,'温州市',12);
insert into city(code,name,province_code) values(102,'嘉兴市',12);
insert into city(code,name,province_code) values(103,'湖州市',12);
insert into city(code,name,province_code) values(104,'绍兴市',12);
insert into city(code,name,province_code) values(105,'金华市',12);
insert into city(code,name,province_code) values(106,'衢州市',12);
insert into city(code,name,province_code) values(107,'舟山市',12);
insert into city(code,name,province_code) values(108,'台州市',12);
insert into city(code,name,province_code) values(109,'丽水市',12);
--13安徽省(2005年辖：17个地级市；44个市辖区、5县个级市、56个县。)
insert into city(code,name,province_code) values(110,'合肥市',13);
insert into city(code,name,province_code) values(111,'芜湖市',13);
insert into city(code,name,province_code) values(112,'蚌埠市',13);
insert into city(code,name,province_code) values(113,'淮南市',13);
insert into city(code,name,province_code) values(114,'马鞍山市',13);
insert into city(code,name,province_code) values(115,'淮北市',13);
insert into city(code,name,province_code) values(116,'铜陵市',13);
insert into city(code,name,province_code) values(117,'安庆市',13);
insert into city(code,name,province_code) values(118,'黄山市',13);
insert into city(code,name,province_code) values(119,'滁州市',13);
insert into city(code,name,province_code) values(120,'阜阳市',13);
insert into city(code,name,province_code) values(121,'宿州市',13);
insert into city(code,name,province_code) values(122,'巢湖市',13);
insert into city(code,name,province_code) values(123,'六安市',13);
insert into city(code,name,province_code) values(124,'亳州市',13);
insert into city(code,name,province_code) values(125,'池州市',13);
insert into city(code,name,province_code) values(126,'宣城市',13);
--14福建省(2006年辖：9个地级市；26个市辖区、14个县级市、45个县。)
insert into city(code,name,province_code) values(127,'福州市',14);
insert into city(code,name,province_code) values(128,'厦门市',14);
insert into city(code,name,province_code) values(129,'莆田市',14);
insert into city(code,name,province_code) values(130,'三明市',14);
insert into city(code,name,province_code) values(131,'泉州市',14);
insert into city(code,name,province_code) values(132,'漳州市',14);
insert into city(code,name,province_code) values(133,'南平市',14);
insert into city(code,name,province_code) values(134,'龙岩市',14);
insert into city(code,name,province_code) values(135,'宁德市',14);
--15江西省(2006年全省辖：11个地级市；19个市辖区、10个县级市、70个县。)
insert into city(code,name,province_code) values(136,'南昌市',15);
insert into city(code,name,province_code) values(137,'景德镇市',15);
insert into city(code,name,province_code) values(138,'萍乡市',15);
insert into city(code,name,province_code) values(139,'九江市',15);
insert into city(code,name,province_code) values(140,'新余市',15);
insert into city(code,name,province_code) values(141,'鹰潭市',15);
insert into city(code,name,province_code) values(142,'赣州市',15);
insert into city(code,name,province_code) values(143,'吉安市',15);
insert into city(code,name,province_code) values(144,'宜春市',15);
insert into city(code,name,province_code) values(145,'抚州市',15);
insert into city(code,name,province_code) values(146,'上饶市',15);
--16山东省(2005年，辖：17个地级市；49个市辖区、31个县级市、60个县。)
insert into city(code,name,province_code) values(147,'济南市',16);
insert into city(code,name,province_code) values(148,'青岛市',16);
insert into city(code,name,province_code) values(149,'淄博市',16);
insert into city(code,name,province_code) values(150,'枣庄市',16);
insert into city(code,name,province_code) values(151,'东营市',16);
insert into city(code,name,province_code) values(152,'烟台市',16);
insert into city(code,name,province_code) values(153'潍坊市',16);
insert into city(code,name,province_code) values(154,'济宁市',16);
insert into city(code,name,province_code) values(155,'泰安市',16);
insert into city(code,name,province_code) values(156,'威海市',16);
insert into city(code,name,province_code) values(157,'日照市',16);
insert into city(code,name,province_code) values(158,'莱芜市',16);
insert into city(code,name,province_code) values(159,'临沂市',16);
insert into city(code,name,province_code) values(160,'德州市',16);
insert into city(code,name,province_code) values(161,'聊城市',16);
insert into city(code,name,province_code) values(162,'滨州市',16);
insert into city(code,name,province_code) values(163,'菏泽市',16);
--17河南省（2005年辖：17个地级市；50个市辖区、21个县级市、88个县。）
insert into city(code,name,province_code) values(164,'郑州市',17);
insert into city(code,name,province_code) values(165,'开封市',17);
insert into city(code,name,province_code) values(166,'洛阳市',17);
insert into city(code,name,province_code) values(167,'平顶山市',17);
insert into city(code,name,province_code) values(168,'安阳市',17);
insert into city(code,name,province_code) values(169,'鹤壁市',17);
insert into city(code,name,province_code) values(170,'新乡市',17);
insert into city(code,name,province_code) values(171,'焦作市',17);
insert into city(code,name,province_code) values(172,'濮阳市',17);
insert into city(code,name,province_code) values(173,'许昌市',17);
insert into city(code,name,province_code) values(174,'漯河市',17);
insert into city(code,name,province_code) values(175,'三门峡市',17);
insert into city(code,name,province_code) values(176,'南阳市',17);
insert into city(code,name,province_code) values(177,'商丘市',17);
insert into city(code,name,province_code) values(178,'信阳市',17);
insert into city(code,name,province_code) values(179,'周口市',17);
insert into city(code,name,province_code) values(180,'驻马店市',17);
insert into city(code,name,province_code) values(181,'济源市',17);
--18湖北省（截至2005年12月31日，全省辖13个地级单位（12个地级市、1个自
治州）；102县级单位（38个市辖区、24个县级市、37个县、2个自治县、1个林区），共有1220个乡级单位（277个街道、733个镇、210个乡）。）
insert into city(code,name,province_code) values(182,'武汉市',18);
insert into city(code,name,province_code) values(183,'黄石市',18);
insert into city(code,name,province_code) values(184,'十堰市',18);
insert into city(code,name,province_code) values(185,'荆州市',18);
insert into city(code,name,province_code) values(186,'宜昌市',18);
insert into city(code,name,province_code) values(187,'襄樊市',18);
insert into city(code,name,province_code) values(188,'鄂州市',18);
insert into city(code,name,province_code) values(189,'荆门市',18);
insert into city(code,name,province_code) values(190,'孝感市',18);
insert into city(code,name,province_code) values(191,'黄冈市',18);
insert into city(code,name,province_code) values(192,'咸宁市',18);
insert into city(code,name,province_code) values(193,'随州市',18);
insert into city(code,name,province_code) values(194,'仙桃市',18);
insert into city(code,name,province_code) values(195,'天门市',18);
insert into city(code,name,province_code) values(196,'潜江市',18);
insert into city(code,name,province_code) values(197,'神农架林区',18);
insert into city(code,name,province_code) values(198,'恩施土家族苗族自治州',18);
--19湖南省（2005年辖：13个地级市、1个自治州；34个市辖区、16个县级市、65个县、7个自治县。）
insert into city(code,name,province_code) values(199,'长沙市',19);
insert into city(code,name,province_code) values(200,'株洲市',19);
insert into city(code,name,province_code) values(201,'湘潭市',19);
insert into city(code,name,province_code) values(202,'衡阳市',19);
insert into city(code,name,province_code) values(203,'邵阳市',19);
insert into city(code,name,province_code) values(204,'岳阳市',19);
insert into city(code,name,province_code) values(205,'常德市',19);
insert into city(code,name,province_code) values(206,'张家界市',19);
insert into city(code,name,province_code) values(207,'益阳市',19);
insert into city(code,name,province_code) values(208,'郴州市',19);
insert into city(code,name,province_code) values(209,'永州市',19);
insert into city(code,name,province_code) values(210,'怀化市',19);
insert into city(code,name,province_code) values(211,'娄底市',19);
insert into city(code,name,province_code) values(212,'湘西土家族苗族自治州',19);
--20广东省（截至2005年12月31日，广东省辖：21个地级市，54个市辖区、23个县级市、41个县、3个自治县，429个街道办事处、1145个镇、4个乡、7个民族乡。）
insert into city(code,name,province_code) values(213,'广州市',20);
insert into city(code,name,province_code) values(214,'深圳市',20);
insert into city(code,name,province_code) values(215,'珠海市',20);
insert into city(code,name,province_code) values(216,'汕头市',20);
insert into city(code,name,province_code) values(217,'韶关市',20);
insert into city(code,name,province_code) values(218,'佛山市',20);
insert into city(code,name,province_code) values(219,'江门市',20);
insert into city(code,name,province_code) values(220,'湛江市',20);
insert into city(code,name,province_code) values(221,'茂名市',20);
insert into city(code,name,province_code) values(222,'肇庆市',20);
insert into city(code,name,province_code) values(223,'惠州市',20);
insert into city(code,name,province_code) values(224,'梅州市',20);
insert into city(code,name,province_code) values(225,'汕尾市',20);
insert into city(code,name,province_code) values(226,'河源市',20);
insert into city(code,name,province_code) values(227,'阳江市',20);
insert into city(code,name,province_code) values(228,'清远市',20);
insert into city(code,name,province_code) values(229,'东莞市',20);
insert into city(code,name,province_code) values(230,'中山市',20);
insert into city(code,name,province_code) values(231,'潮州市',20);
insert into city(code,name,province_code) values(232,'揭阳市',20);
insert into city(code,name,province_code) values(233,'云浮市',20);
--21甘肃省（2006年辖：12个地级市、2个自治州；17个市辖区、4个县级市、58个县、7个自治县。）
insert into city(code,name,province_code) values(234,'兰州市',21);
insert into city(code,name,province_code) values(235,'金昌市',21);
insert into city(code,name,province_code) values(236,'白银市',21);
insert into city(code,name,province_code) values(237,'天水市',21);
insert into city(code,name,province_code) values(238,'嘉峪关市',21);
insert into city(code,name,province_code) values(239,'武威市',21);
insert into city(code,name,province_code) values(240,'张掖市',21);
insert into city(code,name,province_code) values(241,'平凉市',21);
insert into city(code,name,province_code) values(242,'酒泉市',21);
insert into city(code,name,province_code) values(243,'庆阳市',21);
insert into city(code,name,province_code) values(244,'定西市',21);
insert into city(code,name,province_code) values(245,'陇南市',21);
insert into city(code,name,province_code) values(246,'临夏回族自治州',21);
insert into city(code,name,province_code) values(247,'甘南藏族自治州',21);
--22四川省（2006年辖：18个地级市、3个自治州；43个市辖区、14个县级市、120个县、4个自治县。）
insert into city(code,name,province_code) values(248,'成都市',22);
insert into city(code,name,province_code) values(249,'自贡市',22);
insert into city(code,name,province_code) values(250,'攀枝花市',22);
insert into city(code,name,province_code) values(251,'泸州市',22);
insert into city(code,name,province_code) values(252,'德阳市',22);
insert into city(code,name,province_code) values(253,'绵阳市',22);
insert into city(code,name,province_code) values(254,'广元市',22);
insert into city(code,name,province_code) values(255,'遂宁市',22);
insert into city(code,name,province_code) values(256,'内江市',22);
insert into city(code,name,province_code) values(257,'乐山市',22);
insert into city(code,name,province_code) values(258,'南充市',22);
insert into city(code,name,province_code) values(259,'眉山市',22);
insert into city(code,name,province_code) values(260,'宜宾市',22);
insert into city(code,name,province_code) values(261,'广安市',22);
insert into city(code,name,province_code) values(262,'达州市',22);
insert into city(code,name,province_code) values(263,'雅安市',22);
insert into city(code,name,province_code) values(264,'巴中市',22);
insert into city(code,name,province_code) values(265,'资阳市',22);
insert into city(code,name,province_code) values(266,'阿坝藏族羌族自治州',22);
insert into city(code,name,province_code) values(267,'甘孜藏族自治州',22);
insert into city(code,name,province_code) values(268,'凉山彝族自治州',22);
/**//****************************************
--23山东省(2005年，辖：17个地级市；49个市辖区、31个县级市、60个县。)
insert into city(code,name,province_code) values(269,'济南市',16);
insert into city(code,name,province_code) values(270,'青岛市',16);
insert into city(code,name,province_code) values(271,'淄博市',16);
insert into city(code,name,province_code) values(272,'枣庄市',16);
insert into city(code,name,province_code) values(273,'东营市',16);
insert into city(code,name,province_code) values(274,'烟台市',16);
insert into city(code,name,province_code) values(275,'潍坊市',16);
insert into city(code,name,province_code) values(276,'济宁市',16);
insert into city(code,name,province_code) values(277,'泰安市',16);
insert into city(code,name,province_code) values(278,'威海市',16);
insert into city(code,name,province_code) values(279,'日照市',16);
insert into city(code,name,province_code) values(280,'莱芜市',16);
insert into city(code,name,province_code) values(281,'临沂市',16);
insert into city(code,name,province_code) values(282,'德州市',16);
insert into city(code,name,province_code) values(283,'聊城市',16);
insert into city(code,name,province_code) values(284,'滨州市',16);
insert into city(code,name,province_code) values(285,'菏泽市',16);
*************************************/
--24贵州省(2006年辖：4个地级市、2个地区、3个自治州；10个市辖区、9个县级市、56个县、11个自治县、2个特区。)
insert into city(code,name,province_code) values(286,'贵阳市',24);
insert into city(code,name,province_code) values(287,'六盘水市',24);
insert into city(code,name,province_code) values(288,'遵义市',24);
insert into city(code,name,province_code) values(289,'安顺市',24);
insert into city(code,name,province_code) values(290,'铜仁地区',24);
insert into city(code,name,province_code) values(291,'毕节地区',24);
insert into city(code,name,province_code) values(292,'黔西南布依族苗族自治州',24);
insert into city(code,name,province_code) values(293,'黔东南苗族侗族自治州',24);
insert into city(code,name,province_code) values(294,'黔南布依族苗族自治州',24);
--25海南省(2003－2005年　全省有2个地级市，6个县级市，4个县，6个民族自治县，4个市辖区，1个办事处（西南中沙群岛办事处，县级）。)
insert into city(code,name,province_code) values(295,'海口市',25);
insert into city(code,name,province_code) values(296,'三亚市',25);
insert into city(code,name,province_code) values(297,'五指山市',25);
insert into city(code,name,province_code) values(298,'琼海市',25);
insert into city(code,name,province_code) values(299,'儋州市',25);
insert into city(code,name,province_code) values(300,'文昌市',25);
insert into city(code,name,province_code) values(301,'万宁市',25);
insert into city(code,name,province_code) values(302,'东方市',25);
insert into city(code,name,province_code) values(303,'澄迈县',25);
insert into city(code,name,province_code) values(304,'定安县',25);
insert into city(code,name,province_code) values(305,'屯昌县',25);
insert into city(code,name,province_code) values(306,'临高县',25);
insert into city(code,name,province_code) values(307,'白沙黎族自治县',25);
insert into city(code,name,province_code) values(308,'昌江黎族自治县',25);
insert into city(code,name,province_code) values(309,'乐东黎族自治县',25);
insert into city(code,name,province_code) values(310,'陵水黎族自治县',25);
insert into city(code,name,province_code) values(311,'保亭黎族苗族自治县',25);
insert into city(code,name,province_code) values(312,'琼中黎族苗族自治县',25);
--26云南省(2006年辖：8个地级市、8个自治州；12个市辖区、9个县级市、79个县、29个自治县。)
insert into city(code,name,province_code) values(313,'昆明市',26);
insert into city(code,name,province_code) values(315,'曲靖市',26);
insert into city(code,name,province_code) values(316,'玉溪市',26);
insert into city(code,name,province_code) values(317,'保山市',26);
insert into city(code,name,province_code) values(318,'昭通市',26);
insert into city(code,name,province_code) values(319,'丽江市',26);
insert into city(code,name,province_code) values(320,'思茅市',26);
insert into city(code,name,province_code) values(321,'临沧市',26);
insert into city(code,name,province_code) values(322,'文山壮族苗族自治州',26);
insert into city(code,name,province_code) values(323,'红河哈尼族彝族自治州',26);
insert into city(code,name,province_code) values(324,'西双版纳傣族自治州',26);
insert into city(code,name,province_code) values(325,'楚雄彝族自治州',26);
insert into city(code,name,province_code) values(326,'大理白族自治州',26);
insert into city(code,name,province_code) values(327,'德宏傣族景颇族自治州',26);
insert into city(code,name,province_code) values(328,'怒江傈傈族自治州',26);
insert into city(code,name,province_code) values(329,'迪庆藏族自治州',26);
--27青海省(2006年辖：1个地级市、1个地区、6个自治州；4个市辖区、2个县级市、30个县、7个自治县。)
insert into city(code,name,province_code) values(330,'西宁市',27);
insert into city(code,name,province_code) values(331,'海东地区',27);
insert into city(code,name,province_code) values(332,'海北藏族自治州',27);
insert into city(code,name,province_code) values(333,'黄南藏族自治州',27);
insert into city(code,name,province_code) values(334,'海南藏族自治州',27);
insert into city(code,name,province_code) values(335,'果洛藏族自治州',27);
insert into city(code,name,province_code) values(336,'玉树藏族自治州',27);
insert into city(code,name,province_code) values(337,'海西蒙古族藏族自治州',27);
--28陕西省(2006年辖：10个地级市；24个市辖区、3个县级市、80个县。)
insert into city(code,name,province_code) values(338,'西安市',28);
insert into city(code,name,province_code) values(339,'铜川市',28);
insert into city(code,name,province_code) values(340,'宝鸡市',28);
insert into city(code,name,province_code) values(341,'咸阳市',28);
insert into city(code,name,province_code) values(342,'渭南市',28);
insert into city(code,name,province_code) values(343,'延安市',28);
insert into city(code,name,province_code) values(344,'汉中市',28);
insert into city(code,name,province_code) values(345,'榆林市',28);
insert into city(code,name,province_code) values(346,'安康市',28);
insert into city(code,name,province_code) values(347,'商洛市',28);
--29广西壮族自治区(2005年辖：14个地级市；34个市辖区、7个县级市、56个县、12个自治县。)
insert into city(code,name,province_code) values(348,'南宁市',29);
insert into city(code,name,province_code) values(349,'柳州市',29);
insert into city(code,name,province_code) values(350,'桂林市',29);
insert into city(code,name,province_code) values(351,'梧州市',29);
insert into city(code,name,province_code) values(352,'北海市',29);
insert into city(code,name,province_code) values(353,'防城港市',29);
insert into city(code,name,province_code) values(354,'钦州市',29);
insert into city(code,name,province_code) values(355,'贵港市',29);
insert into city(code,name,province_code) values(356,'玉林市',29);
insert into city(code,name,province_code) values(357,'百色市',29);
insert into city(code,name,province_code) values(358,'贺州市',29);
insert into city(code,name,province_code) values(359,'河池市',29);
insert into city(code,name,province_code) values(360,'来宾市',29);
insert into city(code,name,province_code) values(361,'崇左市',29);
--30西藏自治区(2005年辖：1个地级市、6个地区；1个市辖区、1个县级市、71个县。)
insert into city(code,name,province_code) values(362,'拉萨市',30);
insert into city(code,name,province_code) values(363,'那曲地区',30);
insert into city(code,name,province_code) values(364,'昌都地区',30);
insert into city(code,name,province_code) values(365,'山南地区',30);
insert into city(code,name,province_code) values(366,'日喀则地区',30);
insert into city(code,name,province_code) values(367,'阿里地区',30);
insert into city(code,name,province_code) values(368,'林芝地区',30);
--31宁夏回族自治区
insert into city(code,name,province_code) values(369,'银川市',31);
insert into city(code,name,province_code) values(370,'石嘴山市',31);
insert into city(code,name,province_code) values(371,'吴忠市',31);
insert into city(code,name,province_code) values(372,'固原市',31);
insert into city(code,name,province_code) values(373,'中卫市',31);
--32新疆维吾尔自治区(2005年辖：2个地级市、7个地区、5个自治州；11个市辖区、20个县级市、62个县、6个自治县)
insert into city(code,name,province_code) values(374,'乌鲁木齐市',32);
insert into city(code,name,province_code) values(375,'克拉玛依市',32);
insert into city(code,name,province_code) values(376,'石河子市　',32);
insert into city(code,name,province_code) values(377,'阿拉尔市',32);
insert into city(code,name,province_code) values(378,'图木舒克市',32);
insert into city(code,name,province_code) values(379,'五家渠市',32);
insert into city(code,name,province_code) values(380,'吐鲁番市',32);
insert into city(code,name,province_code) values(381,'阿克苏市',32);
insert into city(code,name,province_code) values(382,'喀什市',32);
insert into city(code,name,province_code) values(383,'哈密市',32);
insert into city(code,name,province_code) values(384,'和田市',32);
insert into city(code,name,province_code) values(385,'阿图什市',32);
insert into city(code,name,province_code) values(386,'库尔勒市',32);
insert into city(code,name,province_code) values(387,'昌吉市　',32);
insert into city(code,name,province_code) values(388,'阜康市',32);
insert into city(code,name,province_code) values(389,'米泉市',32);
insert into city(code,name,province_code) values(390,'博乐市',32);
insert into city(code,name,province_code) values(391,'伊宁市',32);
insert into city(code,name,province_code) values(392,'奎屯市',32);
insert into city(code,name,province_code) values(393,'塔城市',32);
insert into city(code,name,province_code) values(394,'乌苏市',32);
insert into city(code,name,province_code) values(395,'阿勒泰市',32);
--33内蒙古自治区(2006年，辖：9个地级市、3个盟；21个市辖区、11个县级市、17个县、49个旗、3个自治旗。)
insert into city(code,name,province_code) values(396,'呼和浩特市',33);
insert into city(code,name,province_code) values(397,'包头市',33);
insert into city(code,name,province_code) values(398,'乌海市',33);
insert into city(code,name,province_code) values(399,'赤峰市',33);
insert into city(code,name,province_code) values(400,'通辽市',33);
insert into city(code,name,province_code) values(401,'鄂尔多斯市',33);
insert into city(code,name,province_code) values(402,'呼伦贝尔市',33);
insert into city(code,name,province_code) values(403,'巴彦淖尔市',33);
insert into city(code,name,province_code) values(404,'乌兰察布市',33);
insert into city(code,name,province_code) values(405,'锡林郭勒盟',33);
insert into city(code,name,province_code) values(406,'兴安盟',33);
insert into city(code,name,province_code) values(407,'阿拉善盟',33);
--34澳门特别行政区
insert into city(code,name,province_code) values(408,'澳门特别行政区',34);
--35香港特别行政区
insert into city(code,name,province_code) values(409,'香港特别行政区',35);