全国省市区数据表
1 DROP TABLE IF EXISTS `provinces`;
prefer2 CREATE TABLE `provinces` (
3 `id` int(11) NOT NULL auto_increment,
4 `provinceid` varchar(20) NOT NULL,
5 `province` varchar(50) NOT NULL,
6 PRIMARY KEY (`id`)
7 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='省份信息表';
8
9
10 inrt into provinces(id,provinceid,province) values(1,'110000','北京市');
11 inrt into provinces(id,provinceid,province) values(2,'120000','天津市');
12 inrt into provinces(id,provinceid,province) values(3,'130000','河北省');
13 inrt into provinces(id,provinceid,province) values(4,'140000','⼭西省');
14 inrt into provinces(id,provinceid,province) values(5,'150000','内蒙古⾃治区');
15 inrt into provinces(id,provinceid,province) values(6,'210000','辽宁省');
16 inrt into provinces(id,provinceid,province) values(7,'220000','吉林省');
17 inrt into provinces(id,provinceid,province) values(8,'230000','⿊龙江省');
18 inrt into provinces(id,provinceid,province) values(9,'310000','上海市');
19 inrt into provinces(id,provinceid,province) values(10,'320000','江苏省');
20 inrt into provinces(id,provinceid,province) values(11,'330000','浙江省');
21 inrt into provinces(id,provinceid,province) values(12,'340000','安徽省');
22 inrt into provinces(id,provinceid,province) values(13,'350000','福建省');
23 inrt into provinces(id,provinceid,province) values(14,'360000','江西省');
24 inrt into provinces(id,provinceid,province) values(15,'370000','⼭东省');
25 inrt into provinces(id,provinceid,province) values(16,'410000','河南省');
26 inrt into provinces(id,provinceid,province) values(17,'420000','湖北省');
27 inrt into provinces(id,provinceid,province) values(18,'430000','湖南省');
28 inrt into provinces(id,provinceid,province) values(19,'440000','⼴东省');
29 inrt into provinces(id,provinceid,province) values(20,'450000','⼴西壮族⾃治区');
30 inrt into provinces(id,provinceid,province) values(21,'460000','海南省');
31 inrt into provinces(id,provinceid,province) values(22,'500000','重庆市');
32 inrt into provinces(id,provinceid,province) values(23,'510000','四川省');
33 inrt into provinces(id,provinceid,province) values(24,'520000','贵州省');
34 inrt into provinces(id,provinceid,province) values(25,'530000','云南省');
35 inrt into provinces(id,provinceid,province) values(26,'540000','西藏⾃治区');
36 inrt into provinces(id,provinceid,province) values(27,'610000','陕西省');
37 inrt into provinces(id,provinceid,province) values(28,'620000','⽢肃省');
38 inrt into provinces(id,provinceid,province) values(29,'630000','青海省');
39 inrt into provinces(id,provinceid,province) values(30,'640000','宁夏回族⾃治区');
40 inrt into provinces(id,provinceid,province) values(31,'650000','新疆维吾尔⾃治区');
41 inrt into provinces(id,provinceid,province) values(32,'710000','台湾省');
42 inrt into provinces(id,provinceid,province) values(33,'810000','⾹港特别⾏政区');
43 inrt into provinces(id,provinceid,province) values(34,'820000','澳门特别⾏政区');
1 DROP TABLE IF EXISTS `cities`;
2 CREATE TABLE `cities` (
3 `id` int(11) NOT NULL auto_increment,
4 `cityid` varchar(20) NOT NULL,
5 `city` varchar(50) NOT NULL,
6 `provinceid` varchar(20) NOT NULL,
7 PRIMARY KEY (`id`)
8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='⾏政区域地州市信息表';
9
13 inrt into cities(id,cityid,city,provinceid) values(4,'120200','县','120000');
14 inrt into cities(id,cityid,city,provinceid) values(5,'130100','⽯家庄市','130000');
15 inrt into cities(id,cityid,city,provinceid) values(6,'130200','唐⼭市','130000');
16 inrt into cities(id,cityid,city,provinceid) values(7,'130300','秦皇岛市','130000');
17 inrt into cities(id,cityid,city,provinceid) values(8,'130400','邯郸市','130000');
18 inrt into cities(id,cityid,city,provinceid) values(9,'130500','邢台市','130000');
19 inrt into cities(id,cityid,city,provinceid) values(10,'130600','保定市','130000');
20 inrt into cities(id,cityid,city,provinceid) values(11,'130700','张家⼝市','130000');
21 inrt into cities(id,cityid,city,provinceid) values(12,'130800','承德市','130000');
22 inrt into cities(id,cityid,city,provinceid) values(13,'130900','沧州市','130000');
23 inrt into cities(id,cityid,city,provinceid) values(14,'131000','廊坊市','130000');
24 inrt into cities(id,cityid,city,provinceid) values(15,'131100','衡⽔市','130000');
25 inrt into cities(id,cityid,city,provinceid) values(16,'140100','太原市','140000');
26 inrt into cities(id,cityid,city,provinceid) values(17,'140200','⼤同市','140000');
27 inrt into cities(id,cityid,city,provinceid) values(18,'140300','阳泉市','140000');
28 inrt into cities(id,cityid,city,provinceid) values(19,'140400','长治市','140000');
29 inrt into cities(id,cityid,city,provinceid) values(20,'140500','晋城市','140000');
30 inrt into cities(id,cityid,city,provinceid) values(21,'140600','朔州市','140000');
31 inrt into cities(id,cityid,city,provinceid) values(22,'140700','晋中市','140000');
拉拉队口号
32 inrt into cities(id,cityid,city,provinceid) values(23,'140800','运城市','140000');
33 inrt into cities(id,cityid,city,provinceid) values(24,'140900','忻州市','140000');
34 inrt into cities(id,cityid,city,provinceid) values(25,'141000','临汾市','140000');
35 inrt into cities(id,cityid,city,provinceid) values(26,'141100','吕梁市','140000');
36 inrt into cities(id,cityid,city,provinceid) values(27,'150100','呼和浩特市','150000');
37 inrt into cities(id,cityid,city,provinceid) values(28,'150200','包头市','150000');
38 inrt into cities(id,cityid,city,provinceid) values(29,'150300','乌海市','150000');
39 inrt into cities(id,cityid,city,provinceid) values(30,'150400','⾚峰市','150000');
40 inrt into cities(id,cityid,city,provinceid) values(31,'150500','通辽市','150000');
41 inrt into cities(id,cityid,city,provinceid) values(32,'150600','鄂尔多斯市','150000');
42 inrt into cities(id,cityid,city,provinceid) values(33,'150700','呼伦贝尔市','150000');
43 inrt into cities(id,cityid,city,provinceid) values(34,'150800','巴彦淖尔市','150000');
44 inrt into cities(id,cityid,city,provinceid) values(35,'150900','乌兰察布市','150000');
45 inrt into cities(id,cityid,city,provinceid) values(36,'152200','兴安盟','150000');
46 inrt into cities(id,cityid,city,provinceid) values(37,'152500','锡林郭勒盟','150000');
47 inrt into cities(id,cityid,city,provinceid) values(38,'152900','阿拉善盟','150000');
48 inrt into cities(id,cityid,city,provinceid) values(39,'210100','沈阳市','210000');
49 inrt into cities(id,cityid,city,provinceid) values(40,'210200','⼤连市','210000');
50 inrt into cities(id,cityid,city,provinceid) values(41,'210300','鞍⼭市','210000');
51 inrt into cities(id,cityid,city,provinceid) values(42,'210400','抚顺市','210000');
52 inrt into cities(id,cityid,city,provinceid) values(43,'210500','本溪市','210000');
53 inrt into cities(id,cityid,city,provinceid) values(44,'210600','丹东市','210000');
54 inrt into cities(id,cityid,city,provinceid) values(45,'210700','锦州市','210000');
55 inrt into cities(id,cityid,city,provinceid) values(46,'210800','营⼝市','210000');
56 inrt into cities(id,cityid,city,provinceid) values(47,'210900','⾩新市','210000');
57 inrt into cities(id,cityid,city,provinceid) values(48,'211000','辽阳市','210000');
58 inrt into cities(id,cityid,city,provinceid) values(49,'211100','盘锦市','210000');
59 inrt into cities(id,cityid,city,provinceid) values(50,'211200','铁岭市','210000');
60 inrt into cities(id,cityid,city,provinceid) values(51,'211300','朝阳市','210000');
61 inrt into cities(id,cityid,city,provinceid) values(52,'211400','葫芦岛市','210000');
62 inrt into cities(id,cityid,city,provinceid) values(53,'220100','长春市','220000');
63 inrt into cities(id,cityid,city,provinceid) values(54,'220200','吉林市','220000');
64 inrt into cities(id,cityid,city,provinceid) values(55,'220300','四平市','220000');
65 inrt into cities(id,cityid,city,provinceid) values(56,'220400','辽源市','220000');
66 inrt into cities(id,cityid,city,provinceid) values(57,'220500','通化市','220000');
67 inrt into cities(id,cityid,city,provinceid) values(58,'220600','⽩⼭市','220000');
68 inrt into cities(id,cityid,city,provinceid) values(59,'220700','松原市','220000');
69 inrt into cities(id,cityid,city,provinceid) values(60,'220800','⽩城市','220000');
70 inrt into cities(id,cityid,city,provinceid) values(61,'222400','延边朝鲜族⾃治州','220000');
71 inrt into cities(id,cityid,city,provinceid) values(62,'230100','哈尔滨市','230000');
72 inrt into cities(id,cityid,city,provinceid) values(63,'230200','齐齐哈尔市','230000');
73 inrt into cities(id,cityid,city,provinceid) values(64,'230300','鸡西市','230000');
74 inrt into cities(id,cityid,city,provinceid) values(65,'230400','鹤岗市','230000');
82 inrt into cities(id,cityid,city,provinceid) values(73,'231200','绥化市','230000');
83 inrt into cities(id,cityid,city,provinceid) values(74,'232700','⼤兴安岭地区','230000');
84 inrt into cities(id,cityid,city,provinceid) values(75,'310100','市辖区','310000');
85 inrt into cities(id,cityid,city,provinceid) values(76,'310200','县','310000');
86 inrt into cities(id,cityid,city,provinceid) values(77,'320100','南京市','320000');
87 inrt into cities(id,cityid,city,provinceid) values(78,'320200','⽆锡市','320000');
88 inrt into cities(id,cityid,city,provinceid) values(79,'320300','徐州市','320000');
89 inrt into cities(id,cityid,city,provinceid) values(80,'320400','常州市','320000');
90 inrt into cities(id,cityid,city,provinceid) values(81,'320500','苏州市','320000');
91 inrt into cities(id,cityid,city,provinceid) values(82,'320600','南通市','320000');
92 inrt into cities(id,cityid,city,provinceid) values(83,'320700','连云港市','320000');
93 inrt into cities(id,cityid,city,provinceid) values(84,'320800','淮安市','320000');
94 inrt into cities(id,cityid,city,provinceid) values(85,'320900','盐城市','320000');
95 inrt into cities(id,cityid,city,provinceid) values(86,'321000','扬州市','320000');峥嵘岁月什么意思
96 inrt into cities(id,cityid,city,provinceid) values(87,'321100','镇江市','320000');
97 inrt into cities(id,cityid,city,provinceid) values(88,'321200','泰州市','320000');
98 inrt into cities(id,cityid,city,provinceid) values(89,'321300','宿迁市','320000');
99 inrt into cities(id,cityid,city,provinceid) values(90,'330100','杭州市','330000');
100 inrt into cities(id,cityid,city,provinceid) values(91,'330200','宁波市','330000');
101 inrt into cities(id,cityid,city,provinceid) values(92,'330300','温州市','330000');
102 inrt into cities(id,cityid,city,provinceid) values(93,'330400','嘉兴市','330000');
103 inrt into cities(id,cityid,city,provinceid) values(94,'330500','湖州市','330000');
104 inrt into cities(id,cityid,city,provinceid) values(95,'330600','绍兴市','330000');
105 inrt into cities(id,cityid,city,provinceid) values(96,'330700','⾦华市','330000');
106 inrt into cities(id,cityid,city,provinceid) values(97,'330800','衢州市','330000');
107 inrt into cities(id,cityid,city,provinceid) values(98,'330900','⾈⼭市','330000');
108 inrt into cities(id,cityid,city,provinceid) values(99,'331000','台州市','330000');
109 inrt into cities(id,cityid,city,provinceid) values(100,'331100','丽⽔市','330000'); 110 inrt into cities(id,cityid,city,provinceid) values(101,'340100','合肥市','340000'); 111 inrt into cities(id,cityid,city,provinceid) values(102,'340200','芜湖市','340000'); 112 inrt into cities(id,cityid,city,provinceid) values(103,'340300','蚌埠市','340000'); 113 inrt into cities(id,cityid,city,provinceid) values(104,'340400','淮南市','340000'); 114 inrt into cities(id,cityid,city,provinceid) values(105,'340500','马鞍⼭市','340000'); 115 inrt into cities(id,cityid,city,provinceid) values(106,'340600','淮北市','340000'); 116 inrt into cities(id,cityid,city,provinceid) values(107,'340700','铜陵市','340000'); 117 inrt into cities(id,cityid,city,provinceid) values(108,'340800','安庆市','340000'); 118 inrt into cities(id,cityid,city,provinceid) values(109,'341000','黄⼭市','340000'); 119 inrt into cities(id,cityid,city,provinceid) values(110,'341100','滁州市','340000'); 120 inrt into cities(id,cityid,city,provinceid) values(111,'341200','⾩阳市','340000'); 121 inrt into cities(id,cityid,city,provinceid) values(112,'341300','宿州市','340000'); 122 inrt into cities(id,cityid,city,provinceid) values(113,'341400','巢湖市','340000'); 123 inrt into cities(id,cityid,city,provinceid) values(114,'341500','六安市','340000'); 124 inrt into cities(id,cityid,cit
y,provinceid) values(115,'341600','亳州市','340000'); 125 inrt into cities(id,cityid,city,provinceid) values(116,'341700','池州市','340000'); 126 inrt into cities(id,cityid,city,provinceid) values(117,'341800','宣城市','340000'); 127 inrt into cities(id,cityid,city,provinceid) values(118,'350100','福州市','350000'); 128 inrt into cities(id,cityid,city,provinceid) values(119,'350200','厦门市','350000'); 129 inrt into cities(id,cityid,city,provinceid) values(120,'350300','莆⽥市','350000'); 130 inrt into cities(id,cityid,city,provinceid) values(121,'350400','三明市','350000'); 131 inrt into cities(id,cityid,city,provinceid) values(122,'350500','泉州市','350000'); 132 inrt into cities(id,cityid,city,provinceid) values(123,'350600','漳州市','350000'); 133 inrt into cities(id,cityid,city,provinceid) values(124,'350700','南平市','350000'); 134 inrt into cities(id,cityid,city,provinceid) values(125,'350800','龙岩市','350000'); 135 inrt into cities(id,cityid,city,provinceid) values(126,'350900','宁德市','350000'); 136 inrt into cities(id,cityid,city,provinceid) values(127,'360100','南昌市','360000'); 137 inrt into cities(id,cityid,city,provinceid) values(128,'360200','景德镇市','360000'); 138 inrt into cities(id,cityid,city,provinceid) values(129,'360300','萍乡市','360000'); 139 inrt into cities(id,cityid,city,provinceid) values(130,'360400','九江市','360000');
147 inrt into cities(id,cityid,city,provinceid) values(138,'370100','济南市','370000');
148 inrt into cities(id,cityid,city,provinceid) values(139,'370200','青岛市','370000');
149 inrt into cities(id,cityid,city,provinceid) values(140,'370300','淄博市','370000');
150 inrt into cities(id,cityid,city,provinceid) values(141,'370400','枣庄市','370000');
151 inrt into cities(id,cityid,city,provinceid) values(142,'370500','东营市','370000');
152 inrt into cities(id,cityid,city,provinceid) values(143,'370600','烟台市','370000');
153 inrt into cities(id,cityid,city,provinceid) values(144,'370700','潍坊市','370000');
154 inrt into cities(id,cityid,city,provinceid) values(145,'370800','济宁市','370000');
155 inrt into cities(id,cityid,city,provinceid) values(146,'370900','泰安市','370000');
156 inrt into cities(id,cityid,city,provinceid) values(147,'371000','威海市','370000');
157 inrt into cities(id,cityid,city,provinceid) values(148,'371100','⽇照市','370000');
158 inrt into cities(id,cityid,city,provinceid) values(149,'371200','莱芜市','370000');
159 inrt into cities(id,cityid,city,provinceid) values(150,'371300','临沂市','370000');
160 inrt into cities(id,cityid,city,provinceid) values(151,'371400','德州市','370000');
161 inrt into cities(id,cityid,city,provinceid) values(152,'371500','聊城市','370000');
162 inrt into cities(id,cityid,city,provinceid) values(153,'371600','滨州市','370000');
163 inrt into cities(id,cityid,city,provinceid) values(154,'371700','荷泽市','370000');
164 inrt into cities(id,cityid,city,provinceid) values(155,'410100','郑州市','410000');
165 inrt into cities(id,cityid,city,provinceid) values(156,'410200','开封市','410000');
166 inrt into cities(id,cityid,city,provinceid) values(157,'410300','洛阳市','410000');则成语
167 inrt into cities(id,cityid,city,provinceid) values(158,'410400','平顶⼭市','410000');
168 inrt into cities(id,cityid,city,provinceid) values(159,'410500','安阳市','410000');
169 inrt into cities(id,cityid,city,provinceid) values(160,'410600','鹤壁市','410000');
170 inrt into cities(id,cityid,city,provinceid) values(161,'410700','新乡市','410000');
171 inrt into cities(id,cityid,city,provinceid) values(162,'410800','焦作市','410000');
172 inrt into cities(id,cityid,city,provinceid) values(163,'410900','濮阳市','410000');
173 inrt into cities(id,cityid,city,provinceid) values(164,'411000','许昌市','410000');
174 inrt into cities(id,cityid,city,provinceid) values(165,'411100','漯河市','410000');
175 inrt into cities(id,cityid,city,provinceid) values(166,'411200','三门峡市','410000');
176 inrt into cities(id,cityid,city,provinceid) values(167,'411300','南阳市','410000');
177 inrt into cities(id,cityid,city,provinceid) values(168,'411400','商丘市','410000');
178 inrt into cities(id,cityid,city,provinceid) values(169,'411500','信阳市','410000');
ipad型号179 inrt into cities(id,cityid,city,provinceid) values(170,'411600','周⼝市','410000');
180 inrt into cities(id,cityid,city,provinceid) values(171,'411700','驻马店市','410000');
181 inrt into cities(id,cityid,city,provinceid) values(172,'420100','武汉市','420000');
182 inrt into cities(id,cityid,city,provinceid) values(173,'420200','黄⽯市','420000');
183 inrt into cities(id,cityid,city,provinceid) values(174,'420300','⼗堰市','420000');
184 inrt into cities(id,cityid,city,provinceid) values(175,'420500','宜昌市','420000');
185 inrt into cities(id,cityid,city,provinceid) values(176,'420600','襄樊市','420000');
186 inrt into cities(id,cityid,city,provinceid) values(177,'420700','鄂州市','420000');
187 inrt into cities(id,cityid,city,provinceid) values(178,'420800','荆门市','420000');
188 inrt into cities(id,cityid,city,provinceid) values(179,'420900','孝感市','420000');
189 inrt into cities(id,cityid,city,provinceid) values(180,'421000','荆州市','420000');
190 inrt into cities(id,cityid,city,provinceid) values(181,'421100','黄冈市','420000');
孤单的时候191 inrt into cities(id,cityid,city,provinceid) values(182,'421200','咸宁市','420000');
192 inrt into cities(id,cityid,city,provinceid) values(183,'421300','随州市','420000');
193 inrt into cities(id,cityid,city,provinceid) values(184,'422800','恩施⼟家族苗族⾃治州','420000'); 194 inrt into cities(id,cityid,city,provinceid) values(185,'429000','省直辖⾏政单位','420000');
非虚构写作195 inrt into cities(id,cityid,city,provinceid) values(186,'430100','长沙市','430000');
196 inrt into cities(id,cityid,city,provinceid) values(187,'430200','株洲市','430000');
197 inrt into cities(id,cityid,city,provinceid) values(188,'430300','湘潭市','430000');
198 inrt into cities(id,cityid,city,provinceid) values(189,'430400','衡阳市','430000');
199 inrt into cities(id,cityid,city,provinceid) values(190,'430500','邵阳市','430000');
200 inrt into cities(id,cityid,city,provinceid) values(191,'430600','岳阳市','430000');
201 inrt into cities(id,cityid,city,provinceid) values(192,'430700','常德市','430000');
202 inrt into cities(id,cityid,city,provinceid) values(193,'430800','张家界市','430000');
203 inrt into cities(id,cityid,city,provinceid) values(194,'430900','益阳市','430000');
204 inrt into cities(id,cityid,city,provinceid) values(195,'431000','郴州市','430000');
208 inrt into cities(id,cityid,city,provinceid) values(199,'433100','湘西⼟家族苗族⾃治州','430000'); 209 inrt into cities(id,cityid,city,provinceid) values(200,'440100','⼴州市','440000');
210 inrt into cities(id,cityid,city,provinceid) values(201,'440200','韶关市','440000');
211 inrt into cities(id,cityid,city,provinceid) values(202,'440300','深圳市','440000');
212 inrt into cities(id,cityid,city,provinceid) values(203,'440400','珠海市','440000');
213 inrt into cities(id,cityid,city,provinceid) values(204,'440500','汕头市','440000');
214 inrt into cities(id,cityid,city,provinceid) values(205,'440600','佛⼭市','440000');
215 inrt into cities(id,cityid,city,provinceid) values(206,'440700','江门市','440000');
216 inrt into cities(id,cityid,city,provinceid) values(207,'440800','湛江市','440000');
217 inrt into cities(id,cityid,city,provinceid) values(208,'440900','茂名市','440000');
218 inrt into cities(id,cityid,city,provinceid) values(209,'441200','肇庆市','440000');
219 inrt into cities(id,cityid,city,provinceid) values(210,'441300','惠州市','440000');
220 inrt into cities(id,cityid,city,provinceid) values(211,'441400','梅州市','440000');
221 inrt into cities(id,cityid,city,provinceid) values(212,'441500','汕尾市','440000');
222 inrt into cities(id,cityid,city,provinceid) values(213,'441600','河源市','440000');
223 inrt into cities(id,cityid,city,provinceid) values(214,'441700','阳江市','440000');
224 inrt into cities(id,cityid,city,provinceid) values(215,'441800','清远市','440000');
225 inrt into cities(id,cityid,city,provinceid) values(216,'441900','东莞市','440000');
226 inrt into cities(id,cityid,city,provinceid) values(217,'442000','中⼭市','440000');
227 inrt into cities(id,cityid,city,provinceid) values(218,'445100','潮州市','440000');
228 inrt into cities(id,cityid,city,provinceid) values(219,'445200','揭阳市','440000');
229 inrt into cities(id,cityid,city,provinceid) values(220,'445300','云浮市','440000');
230 inrt into cities(id,cityid,city,provinceid) values(221,'450100','南宁市','450000');
231 inrt into cities(id,cityid,city,provinceid) values(222,'450200','柳州市','450000');
232 inrt into cities(id,cityid,city,provinceid) values(223,'450300','桂林市','450000');
233 inrt into cities(id,cityid,city,provinceid) values(224,'450400','梧州市','450000');
234 inrt into cities(id,cityid,city,provinceid) values(225,'450500','北海市','450000');
235 inrt into cities(id,cityid,city,provinceid) values(226,'450600','防城港市','450000');
236 inrt into cities(id,cityid,city,provinceid) values(227,'450700','钦州市','450000');
237 inrt into cities(id,cityid,city,provinceid) values(228,'450800','贵港市','450000');
238 inrt into cities(id,cityid,city,provinceid) values(229,'450900','⽟林市','450000');
239 inrt into cities(id,cityid,city,provinceid) values(230,'451000','百⾊市','450000');
人文学科的重要性240 inrt into cities(id,cityid,city,provinceid) values(231,'451100','贺州市','450000');
241 inrt into cities(id,cityid,city,provinceid) values(232,'451200','河池市','450000');
242 inrt into cities(id,cityid,city,provinceid) values(233,'451300','来宾市','450000');
243 inrt into cities(id,cityid,city,provinceid) values(234,'451400','崇左市','450000');
244 inrt into cities(id,cityid,city,provinceid) values(235,'460100','海⼝市','460000');
245 inrt into cities(id,cityid,city,provinceid) values(236,'460200','三亚市','460000');
246 inrt into cities(id,cityid,city,provinceid) values(237,'469000','省直辖县级⾏政单位','460000'); 247 inrt into cities(id,cityid,city,provinceid) values(238,'500100','市辖区','500000');
248 inrt into cities(id,cityid,city,provinceid) values(239,'500200','县','500000');
249 inrt into cities(id,cityid,city,provinceid) values(240,'500300','市','500000');
250 inrt into cities(id,cityid,city,provinceid) values(241,'510100','成都市','510000');
251 inrt into cities(id,cityid,city,provinceid) values(242,'510300','⾃贡市','510000');
252 inrt into cities(id,cityid,city,provinceid) values(243,'510400','攀枝花市','510000');
253 inrt into cities(id,cityid,city,provinceid) values(244,'510500','泸州市','510000');
254 inrt into cities(id,cityid,city,provinceid) values(245,'510600','德阳市','510000');
255 inrt into cities(id,cityid,city,provinceid) values(246,'510700','绵阳市','510000');
256 inrt into cities(id,cityid,city,provinceid) values(247,'510800','⼴元市','510000');
257 inrt into cities(id,cityid,city,provinceid) values(248,'510900','遂宁市','510000');
258 inrt into cities(id,cityid,city,provinceid) values(249,'511000','内江市','510000');
259 inrt into cities(id,cityid,city,provinceid) values(250,'511100','乐⼭市','510000');
260 inrt into cities(id,cityid,city,provinceid) values(251,'511300','南充市','510000');
261 inrt into cities(id,cityid,city,provinceid) values(252,'511400','眉⼭市','510000');
262 inrt into cities(id,cityid,city,provinceid) values(253,'511500','宜宾市','510000');
263 inrt into cities(id,cityid,city,provinceid) values(254,'511600','⼴安市','510000');
264 inrt into cities(id,cityid,city,provinceid) values(255,'511700','达州市','510000');
265 inrt into cities(id,cityid,city,provinceid) values(256,'511800','雅安市','510000');
266 inrt into cities(id,cityid,city,provinceid) values(257,'511900','巴中市','510000');
267 inrt into cities(id,cityid,city,provinceid) values(258,'512000','资阳市','510000');
268 inrt into cities(id,cityid,city,provinceid) values(259,'513200','阿坝藏族羌族⾃治州','510000'); 269 inrt into cities(id,cityid,city,provinceid) values(260,'513300','⽢孜藏族⾃治州','510000');
