📄 provincecityarea.sql
字号:
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 190,'130928','吴桥县','130900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 191,'130929','献 县','130900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 192,'130930','孟村回族自治县','130900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 193,'130981','泊头市','130900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 194,'130982','任丘市','130900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 195,'130983','黄骅市','130900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 196,'130984','河间市','130900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 197,'131001','市辖区','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 198,'131002','安次区','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 199,'131003','广阳区','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 200,'131022','固安县','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 201,'131023','永清县','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 202,'131024','香河县','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 203,'131025','大城县','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 204,'131026','文安县','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 205,'131028','大厂回族自治县','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 206,'131081','霸州市','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 207,'131082','三河市','131000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 208,'131101','市辖区','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 209,'131102','桃城区','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 210,'131121','枣强县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 211,'131122','武邑县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 212,'131123','武强县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 213,'131124','饶阳县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 214,'131125','安平县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 215,'131126','故城县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 216,'131127','景 县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 217,'131128','阜城县','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 218,'131181','冀州市','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 219,'131182','深州市','131100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 220,'140101','市辖区','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 221,'140105','小店区','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 222,'140106','迎泽区','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 223,'140107','杏花岭区','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 224,'140108','尖草坪区','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 225,'140109','万柏林区','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 226,'140110','晋源区','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 227,'140121','清徐县','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 228,'140122','阳曲县','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 229,'140123','娄烦县','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 230,'140181','古交市','140100')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 231,'140201','市辖区','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 232,'140202','城 区','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 233,'140203','矿 区','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 234,'140211','南郊区','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 235,'140212','新荣区','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 236,'140221','阳高县','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 237,'140222','天镇县','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 238,'140223','广灵县','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 239,'140224','灵丘县','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 240,'140225','浑源县','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 241,'140226','左云县','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 242,'140227','大同县','140200')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 243,'140301','市辖区','140300')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 244,'140302','城 区','140300')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 245,'140303','矿 区','140300')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 246,'140311','郊 区','140300')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 247,'140321','平定县','140300')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 248,'140322','盂 县','140300')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 249,'140401','市辖区','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 250,'140402','城 区','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 251,'140411','郊 区','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 252,'140421','长治县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 253,'140423','襄垣县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 254,'140424','屯留县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 255,'140425','平顺县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 256,'140426','黎城县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 257,'140427','壶关县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 258,'140428','长子县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 259,'140429','武乡县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 260,'140430','沁 县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 261,'140431','沁源县','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 262,'140481','潞城市','140400')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 263,'140501','市辖区','140500')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 264,'140502','城 区','140500')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 265,'140521','沁水县','140500')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 266,'140522','阳城县','140500')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 267,'140524','陵川县','140500')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 268,'140525','泽州县','140500')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 269,'140581','高平市','140500')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 270,'140601','市辖区','140600')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 271,'140602','朔城区','140600')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 272,'140603','平鲁区','140600')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 273,'140621','山阴县','140600')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 274,'140622','应 县','140600')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 275,'140623','右玉县','140600')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 276,'140624','怀仁县','140600')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 277,'140701','市辖区','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 278,'140702','榆次区','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 279,'140721','榆社县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 280,'140722','左权县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 281,'140723','和顺县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 282,'140724','昔阳县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 283,'140725','寿阳县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 284,'140726','太谷县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 285,'140727','祁 县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 286,'140728','平遥县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 287,'140729','灵石县','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 288,'140781','介休市','140700')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 289,'140801','市辖区','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 290,'140802','盐湖区','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 291,'140821','临猗县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 292,'140822','万荣县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 293,'140823','闻喜县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 294,'140824','稷山县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 295,'140825','新绛县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 296,'140826','绛 县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 297,'140827','垣曲县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 298,'140828','夏 县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 299,'140829','平陆县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 300,'140830','芮城县','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 301,'140881','永济市','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 302,'140882','河津市','140800')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 303,'140901','市辖区','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 304,'140902','忻府区','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 305,'140921','定襄县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 306,'140922','五台县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 307,'140923','代 县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 308,'140924','繁峙县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 309,'140925','宁武县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 310,'140926','静乐县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 311,'140927','神池县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 312,'140928','五寨县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 313,'140929','岢岚县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 314,'140930','河曲县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 315,'140931','保德县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 316,'140932','偏关县','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 317,'140981','原平市','140900')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 318,'141001','市辖区','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 319,'141002','尧都区','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 320,'141021','曲沃县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 321,'141022','翼城县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 322,'141023','襄汾县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 323,'141024','洪洞县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 324,'141025','古 县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 325,'141026','安泽县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 326,'141027','浮山县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 327,'141028','吉 县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 328,'141029','乡宁县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 329,'141030','大宁县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 330,'141031','隰 县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 331,'141032','永和县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 332,'141033','蒲 县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 333,'141034','汾西县','141000')
INSERT [area] ([id],[code],[name],[cityId]) VALUES ( 334,'141081','侯马市','141000')
INSERT [a
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -