构造全国省市数据库(七)
nto city values(7,'玉树藏族自治州',27)
insert into city values(8,'海西蒙古族藏族自治州',27)
--28陕西省(2006年辖：10个地级市；24个市辖区、3个县级市、80个县。)
insert into city values(1,'西安市',28)
insert into city values(2,'铜川市',28)
insert into city values(3,'宝鸡市',28)
insert into city values(4,'咸阳市',28)
insert into city values(5,'渭南市',28)
insert into city values(6,'延安市',28)
insert into city values(7,'汉中市',28)
insert into city values(8,'榆林市',28)
insert into city values(9,'安康市',28)
insert into city values(10,'商洛市',28)
--29广西壮族自治区(2005年辖：14个地级市；34个市辖区、7个县级市、56个县、12个自治县。)
insert into city values(1,'南宁市',29)
insert into city values(2,'柳州市',29)
insert into city values(3,'桂林市',29)
insert into city values(4,'梧州市',29)
insert into city values(5,'北海市',29)
insert into city values(6,'防城港市',29)
insert into city values(7,'钦州市',29)
insert into city values(8,'贵港市',29)
insert into city values(9,'玉林市',29)
insert into city values(10,'百色市',29)
insert into city values(11,'贺州市',29)
insert into city values(12,'河池市',29)
insert into city values(13,'来宾市',29)
insert into city values(14,'崇左市',29)
--30西藏自治区(2005年辖：1个地级市、6个地区；1个市辖区、1个县级市、71个县。)
insert into city values(1,'拉萨市',30)
insert into city values(2,'那曲地区',30)
insert into city values(3,'昌都地区',30)
insert into city values(4,'山南地区',30)
insert into city values(5,'日喀则地区',30)
insert into city values(6,'阿里地区',30)
insert into city values(7,'林芝地区',30)
--31宁夏回族自治区
insert into city values(1,'银川市',31)
insert into city values(2,'石嘴山市',31)
insert into city values(3,'吴忠市',31)
insert into city values(4,'固原市',31)
insert into city values(5,'中卫市',31)
--32新疆维吾尔自治区(2005年辖：2个�
丶妒小�7个地区、5个自治州；11个市辖区、20个县级市、62个县、6个自治县)
insert into city values(1,'乌鲁木齐市',32)
insert into city values(2,'克拉玛依市',32)
insert into city values(3,'石河子市 ',32)
insert into city values(4,'阿拉尔市',32)
insert into city values(5,'图木舒克市',32)
insert into city values(6,'五家渠市',32)
insert into city values(7,'吐鲁番市',32)
insert into city values(8,'阿克苏市',32)
insert into city values(9,'喀什市',32)
insert into city values(10,'哈密市',32)
insert into city values(11,'和田市',32)
insert into city values(12,'阿图什市',32)
insert into city values(13,'库尔勒市',32)
insert into city values(14,'昌吉市 ',32)
insert into city values(15,'阜康市',32)
insert into city values(16,'米泉市',32)
insert into city values(17,'博乐市',32)
insert into city values(18,'伊宁市',32)
insert into city values(19,'奎屯市',32)
insert into city values(20,'塔城市',32)
insert into city values(21,'乌苏市',32)
insert into city values(22,'阿勒泰市',32)
--33内蒙古自治区(2006年，辖：9个地级市、3个盟；21个市辖区、11个县级市、17个县、49个旗、3个自治旗。)
insert into city values(1,'呼和浩特市',33)
insert into city values(2,'包头市',33)
insert into city values(3,'乌海市',33)
insert into city values(4,'赤峰市',33)
insert into city values(5,'通辽市',33)
insert into city values(6,'鄂尔多斯市',33)
insert into city values(7,'呼伦贝尔市',33)
insert into city values(8,'巴彦淖尔市',33)
insert into city values(9,'乌兰察布市',33)
insert into city values(10,'锡林郭勒盟',33)
insert into city values(11,'兴安盟',33)
insert into city values(12,'阿拉善盟',33)
--34澳门特别行政区
insert into city values(1,'澳门特别行政区',34)
--35香港特别行政区
insert into city values(1,'香港特别行政区',35)
--------------------------------------------------------------------------------------------------------