|
)
insert into city values(16,'雅安市',22)
insert into city values(17,'巴中市',22)
insert into city values(18,'资阳市',22)
insert into city values(19,'阿坝藏族羌族自治州',22)
insert into city values(20,'甘孜藏族自治州',22)
insert into city values(21,'凉山彝族自治州',22)
/**//****************************************
--23山东省(2005年，辖：17个地级市；49个市辖区、31个县级市、60个县。)
insert into city values(1,'济南市',16)
insert into city values(2,'青岛市',16)
insert into city values(3,'淄博市',16)
insert into city values(4,'枣庄市',16)
insert into city values(5,'东营市',16)
insert into city values(6,'烟台市',16)
insert into city values(7,'潍坊市',16)
insert into city values(8,'济宁市',16)
insert into city values(9,'泰安市',16)
insert into city values(10,'威海市',16)
insert into city values(11,'日照市',16)
insert into city values(12,'莱芜市',16)
insert into city values(13,'临沂市',16)
insert into city values(14,'德州市',16)
insert into city values(15,'聊城市',16)
insert into city values(16,'滨州市',16)
insert into city values(17,'菏泽市',16)
*************************************/
--24贵州省(2006年辖：4个地级市、2个地区、3个自治州；10个市辖区、9个县级市、56个县、11个自治县、2个特区。)
insert into city values(1,'贵阳市',24)
insert into city values(2,'六盘水市',24)
insert into city values(3,'遵义市',24)
insert into city values(4,'安顺市',24)
insert into city values(5,'铜仁地区',24)
insert into city values(6,'毕节地区',24)
insert into city values(7,'黔西南布依族苗族自治州',24)
insert into city values(8,'黔东南苗族侗族自治州',24)
insert into city values(9,'黔南布依族苗族自治州',24)
--25海南省(2003－2005年 全省有2个地级市，6个县级市，4个县，6个民族自治县，4个市辖区，1个办事处（西南中沙群岛办事处，县级）。)
insert into city values(1,'海口市',25)
insert into city values(2,'三亚市',25)
insert into city values(3,'五指山市',25)
insert into city values(4,'琼海市',25)
insert into city values(5,'儋州市',25)
insert into city values(6,'文昌市',25)
insert into city values(7,'万宁市',25)
insert into city values(8,'东方市',25)
insert into city values(9,'澄迈县',25)
insert into city values(10,'定安县',25)
insert into city values(11,'屯昌县',25)
insert into city values(12,'临高县',25)
insert into city values(13,'白沙黎族自治县',25)
insert into city values(14,'昌江黎族自治县',25)
insert into city values(15,'乐东黎族自治县',25)
insert into city values(16,'陵水黎族自治县',25)
insert into city values(17,'保亭黎族苗族自治县',25)
insert into city values(18,'琼中黎族苗族自治县',25)
--26云南省(2006年辖：8个地级市、8个自治州；12个市辖区、9个县级市、79个县、29个自治县。)
insert into city values(1,'昆明市',26)
insert into city values(2,'曲靖市',26)
insert into city values(3,'玉溪市',26)
insert into city values(4,'保山市',26)
insert into city values(5,'昭通市',26)
insert into city values(6,'丽江市',26)
insert into city values(7,'思茅市',26)
insert into city values(8,'临沧市',26)
insert into city values(9,'文山壮族苗族自治州',26)
insert into city values(10,'红河哈尼族彝族自治州',26)
insert into city values(11,'西双版纳傣族自治州',26)
insert into city values(12,'楚雄彝族自治州',26)
insert into city values(13,'大理白族自治州',26)
insert into city values(14,'德宏傣族景颇族自治州',26)
insert into city values(15,'怒江傈傈族自治州',26)
insert into city values(16,'迪庆藏族自治州',26)
--27青海省(2006年辖：1个地级市、1个地区、6个自治州；4个市辖区、2个县级市、30个县、7个自治县。)
insert into city values(1,'西宁市',27)
insert into city values(2,'海东地区',27)
insert into city values(3,'海北藏族自治州',27)
insert into city values(4,'黄南藏族自治州',27)
insert into city values(5,'海南藏族自治州',27)
insert into city values(6,'果洛藏族自治州',27)
insert i |