|
ert into city values(3,'十堰市',18)
insert into city values(4,'荆州市',18)
insert into city values(5,'宜昌市',18)
insert into city values(6,'襄樊市',18)
insert into city values(7,'鄂州市',18)
insert into city values(8,'荆门市',18)
insert into city values(9,'孝感市',18)
insert into city values(10,'黄冈市',18)
insert into city values(11,'咸宁市',18)
insert into city values(12,'随州市',18)
insert into city values(13,'仙桃市',18)
insert into city values(14,'天门市',18)
insert into city values(15,'潜江市',18)
insert into city values(16,'神农架林区',18)
insert into city values(17,'恩施土家族苗族自治州',18)
--19湖南省（2005年辖：13个地级市、1个自治州；34个市辖区、16个县级市、65个县、7个自治县。）
insert into city values(1,'长沙市',19)
insert into city values(2,'株洲市',19)
insert into city values(3,'湘潭市',19)
insert into city values(4,'衡阳市',19)
insert into city values(5,'邵阳市',19)
insert into city values(6,'岳阳市',19)
insert into city values(7,'常德市',19)
insert into city values(8,'张家界市',19)
insert into city values(9,'益阳市',19)
insert into city values(10,'郴州市',19)
insert into city values(11,'永州市',19)
insert into city values(12,'怀化市',19)
insert into city values(13,'娄底市',19)
insert into city values(14,'湘西土家族苗族自治州',19)
--20广东省（截至2005年12月31日，广东省辖：21个地级市，54个市辖区、23个县级市、41个县、3个自治县，429个街道办事处、1145个镇、4个乡、7个民族乡。）
insert into city values(1,'广州市',20)
insert into city values(2,'深圳市',20)
insert into city values(3,'珠海市',20)
insert into city values(4,'汕头市',20)
insert into city values(5,'韶关市',20)
insert into city values(6,'佛山市',20)
insert into city values(7,'江门市',20)
insert into city values(8,'湛江市',20)
insert into city values(9,'茂名市',20)
insert into city values(10,'肇庆市',20)
insert into city values(11,'惠州市',20)
insert into city values(12,'梅州市',20)
insert into city values(13,'汕尾市',20)
insert into city values(14,'河源市',20)
insert into city values(15,'阳江市',20)
insert into city values(16,'清远市',20)
insert into city values(17,'东莞市',20)
insert into city values(18,'中山市',20)
insert into city values(19,'潮州市',20)
insert into city values(20,'揭阳市',20)
insert into city values(21,'云浮市',20)
--21甘肃省（2006年辖：12个地级市、2个自治州；17个市辖区、4个县级市、58个县、7个自治县。）
insert into city values(1,'兰州市',21)
insert into city values(2,'金昌市',21)
insert into city values(3,'白银市',21)
insert into city values(4,'天水市',21)
insert into city values(5,'嘉峪关市',21)
insert into city values(6,'武威市',21)
insert into city values(7,'张掖市',21)
insert into city values(8,'平凉市',21)
insert into city values(9,'酒泉市',21)
insert into city values(10,'庆阳市',21)
insert into city values(11,'定西市',21)
insert into city values(12,'陇南市',21)
insert into city values(13,'临夏回族自治州',21)
insert into city values(14,'甘南藏族自治州',21)
--22四川省（2006年辖：18个地级市、3个自治州；43个市辖区、14个县级市、120个县、4个自治县。）
insert into city values(1,'成都市',22)
insert into city values(2,'自贡市',22)
insert into city values(3,'攀枝花市',22)
insert into city values(4,'泸州市',22)
insert into city values(5,'德阳市',22)
insert into city values(6,'绵阳市',22)
insert into city values(7,'广元市',22)
insert into city values(8,'遂宁市',22)
insert into city values(9,'内江市',22)
insert into city values(10,'乐山市',22)
insert into city values(11,'南充市',22)
insert into city values(12,'眉山市',22)
insert into city values(13,'宜宾市',22)
insert into city values(14,'广安市',22)
insert into city values(15,'达州市',22 |