---------------请问里有有中国省份和城市的SQL数据表--------------谢谢

Question

-

Answer 1

"id" "shengname" "shengNo" "shengorder"
1 "安徽" "1" 1
2 "北京" "0" 0
3 "山东省" "2" 2
4 "江苏省" "3" 3
5 "上海市" "4" 4
6 "广东省" "5" 5
7 "浙江省" "6" 6
8 "福建省" "7" 7
9 "重庆市" "8" 8
10 "甘肃省" "9" 9
11 "广西省" "10" 10
12 "贵州省" "11" 11
13 "海南省" "12" 12
14 "河北省" "13" 13
15 "河南省" "14" 14
16 "黑龙江省" "15" 15
17 "湖北省" "16" 16
18 "湖南省" "17" 17
19 "江西省" "18" 18
20 "吉林省" "19" 19
21 "辽宁省" "20" 20
22 "内蒙古" "21" 21
23 "宁夏" "22" 22
24 "青海省" "23" 23
25 "山西省" "24" 24
26 "陕西省" "25" 25
27 "四川省" "26" 26
28 "天津市" "27" 27
29 "新疆" "28" 28
30 "西藏" "29" 29
31 "云南省" "30" 30
32 "香港" "31" 31
33 "澳门" "32" 32
34 "台湾" "33" 33
35 "国外与其它" "34" 34

Answer 2

上网下一个吧，ACCESS的，不大，挺好

Answer 3

"id" "shiname" "shiNo" "shiorder" "Shengid"
1 "合肥市" "1" 1 1
2 "芜湖市" "2" 2 1
3 "北京市" "1" 1 2
4 "安庆市" "3" 3 1
5 "巢湖市" "4" 4 1
6 "滁州市" "5" 5 1
7 "淮南市" "6" 6 1
8 "马鞍山市" "7" 7 1
9 "宿州市" "8" 8 1
10 "宣州市" "9" 9 1
11 "蚌埠市" "10" 10 1
12 "池州地区" "11" 11 1
13 "阜阳市" "12" 12 1
14 "淮北市" "13" 13 1
15 "黄山市" "14" 14 1
16 "六安市" "15" 15 1
17 "铜陵市" "16" 16 1
18 "亳州市" "17" 17 1
19 "济南市" "1" 1 3
20 "东营市" "2" 2 3
21 "滨州地区" "3" 3 3
22 "淄博市" "4" 4 3
23 "德州市" "5" 5 3
24 "济宁市" "6" 6 3
25 "聊城地区" "7" 7 3
26 "临沂市" "8" 8 3
27 "莱芜市" "9" 9 3
28 "青岛市" "10" 10 3
29 "日照市" "11" 11 3
30 "威海市" "12" 12 3
31 "泰安市" "13" 13 3
32 "潍坊市" "14" 14 3
33 "烟台市" "15" 15 3
34 "菏泽地区" "16" 16 3
35 "枣庄市" "171" 17 3
36 "南京市" "1" 1 4
37 "淮阴市" "2" 2 4
38 "常州市" "3" 3 4
39 "连云港市" "4" 4 4
40 "南通市" "5" 5 4
41 "徐州市" "6" 6 4
42 "苏州市" "7" 7 4
43 "无锡市" "8" 8 4
44 "盐城市" "9" 9 4
45 "扬州市" "10" 10 4
46 "镇江市" "11" 11 4
47 "泰州市" "12" 12 4
48 "宿迁市" "13" 13 4
49 "上海市" "1" 1 5
50 "广州市" "1" 1 6
51 "佛山市" "2" 2 6
52 "惠州市" "3" 3 6
53 "东莞市" "4" 4 6
54 "江门市" "5" 5 6
55 "揭阳市" "5" 5 6
56 "潮州市" "6" 6 6
57 "茂名市" "7" 7 6
58 "梅州市" "8" 8 6
59 "清远市" "9" 9 6
60 "汕头市" "10" 10 6
61 "汕尾市" "11" 11 6
62 "深圳市" "12" 12 6
63 "韶关市" "13" 13 6
64 "阳江市" "14" 14 6
65 "河源市" "15" 15 6
66 "云浮市" "16" 16 6
67 "中山市" "17" 17 6
68 "珠海市" "18" 18 6
69 "湛江市" "19" 19 6
70 "湛江市" "20" 20 6
71 "江门市" "21" 21 6
72 "杭州市" "1" 1 7
73 "嘉兴市" "2" 2 7
74 "金华市" "3" 3 7
75 "衢州市" "4" 4 7
76 "丽水地区" "5" 5 7
77 "宁波市" "6" 6 7
78 "绍兴市" "7" 7 7
79 "台州市" "8" 8 7
80 "温州市" "9" 9 7
81 "舟山市" "10" 10 7
82 "湖州市" "11" 11 7
83 "福州市" "1" 1 8
84 "龙岩地区" "2" 2 8
85 "南平市" "3" 3 8
86 "宁德地区" "4" 4 8
87 "莆田市" "5" 5 8
88 "泉州市" "6" 6 8
89 "三明市" "7" 7 8
90 "厦门市" "8" 8 8
91 "漳州市" "9" 9 8
92 "重庆市" "1" 1 9
93 "涪陵市" "2" 2 9
94 "黔江地区" "3" 3 9
95 "万县市" "4" 4 9
96 "兰州市" "1" 1 10
97 "甘南藏族自治州" "2" 2 10
98 "定西地区" "3" 3 10
99 "白银市" "4" 4 9
100 "嘉峪关市" "4" 4 10
101 "金昌市" "5" 5 10
102 "酒泉地区" "6" 6 10
103 "临夏回族自治州" "7" 7 10
104 "陇南地区" "8" 8 10
105 "平凉地区" "9" 9 10
106 "庆阳地区" "10" 10 10
107 "天水市" "11" 11 10
108 "武威地区" "12" 12 10
109 "张掖地区" "13" 13 10
110 "南宁市" "1" 1 11
111 "防城港市" "2" 2 11
112 "北海市" "3" 3 11
113 "百色地区" "4" 4 11
114 "桂林地区" "5" 5 11
115 "桂林市" "6" 6 11
116 "柳州地区" "7" 7 11
117 "柳州市" "8" 8 11
118 "南宁地区" "9" 9 11
119 "钦州市" "10" 10 11
120 "梧州地区" "11" 11 11
121 "梧州市" "12" 12 11
122 "河池地区" "13" 13 11
123 "玉林地区" "14" 14 11
124 "贵港市" "15" 15 11
125 "贵阳市" "1" 1 12
126 "毕节地区" "2" 2 12
127 "遵义地区" "3" 3 12
128 "安顺地区" "4" 4 12
129 "六盘水市" "5" 5 12
130 "黔东南苗族侗族自治州" "6" 6 12
131 "黔南布依族苗族自治州" "7" 7 12
132 "黔西南布依族苗族自治州" "8" 8 12
133 "铜仁地区" "9" 9 12
134 "三亚市" "1" 1 13
135 "海口市" "2" 2 13
136 "石家庄市" "1" 1 14
137 "邯郸市" "2" 2 14
138 "邢台市" "3" 3 14
139 "保定市" "4" 4 14
140 "张家口市" "5" 5 14
141 "沧州市" "6" 6 14
142 "承德市" "7" 7 14
143 "廊坊市" "8" 8 14
144 "秦皇岛市" "9" 9 14
145 "唐山市" "10" 10 14
146 "衡水地区" "11" 11 14
147 "郑州市" "1" 1 15
148 "开封市" "2" 2 15
149 "驻马店地区" "3" 3 15
150 "安阳市" "4" 4 15
151 "焦作市" "5" 5 15