全国省市区县数据库脚本

来源：互联网发布：slack for windows 编辑：程序博客网时间：2024/05/01 05:04

由于项目需要，整理了一套全国的省市区县数据库脚本。创建表后可以成功执行语句。

insert into tbl_province(codeid,parentid,name,createtime) values(11,0,'北京',now());insert into tbl_province(codeid,parentid,name,createtime) values(1101,11,'北京市辖',now());insert into tbl_province(codeid,parentid,name,createtime) values(110101,1101,'东城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110102,1101,'西城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110103,1101,'崇文区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110104,1101,'宣武区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110105,1101,'朝阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110106,1101,'丰台区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110107,1101,'石景山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110108,1101,'海淀区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110109,1101,'门头沟区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110111,1101,'房山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110112,1101,'通州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110113,1101,'顺义区',now());insert into tbl_province(codeid,parentid,name,createtime) values(110114,1101,'昌平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(1102,11,'北京县辖',now());insert into tbl_province(codeid,parentid,name,createtime) values(110224,1102,'大兴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(110226,1102,'平谷县',now());insert into tbl_province(codeid,parentid,name,createtime) values(110227,1102,'怀柔县',now());insert into tbl_province(codeid,parentid,name,createtime) values(110228,1102,'密云县',now());insert into tbl_province(codeid,parentid,name,createtime) values(110229,1102,'延庆县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(12,0,'天津',now());insert into tbl_province(codeid,parentid,name,createtime) values(1201,12,'天津市辖',now());insert into tbl_province(codeid,parentid,name,createtime) values(120101,1201,'和平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120102,1201,'河东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120103,1201,'河西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120104,1201,'南开区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120105,1201,'河北区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120106,1201,'红桥区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120107,1201,'塘沽区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120108,1201,'汉沽区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120109,1201,'大港区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120110,1201,'东丽区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120111,1201,'西青区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120112,1201,'津南区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120113,1201,'北辰区',now());insert into tbl_province(codeid,parentid,name,createtime) values(120114,1201,'武清区',now());insert into tbl_province(codeid,parentid,name,createtime) values(1202,12,'天津县辖',now());insert into tbl_province(codeid,parentid,name,createtime) values(120221,1202,'宁河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(120223,1202,'静海县',now());insert into tbl_province(codeid,parentid,name,createtime) values(120224,1202,'宝坻县',now());insert into tbl_province(codeid,parentid,name,createtime) values(120225,1202,'蓟县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(13,0,'河北',now());insert into tbl_province(codeid,parentid,name,createtime) values(1301,13,'石家庄',now());insert into tbl_province(codeid,parentid,name,createtime) values(130101,1301,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130102,1301,'长安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130103,1301,'桥东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130104,1301,'桥西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130105,1301,'新华区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130106,1301,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130107,1301,'井陉矿区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130121,1301,'井陉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130123,1301,'正定县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130124,1301,'栾城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130125,1301,'行唐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130126,1301,'灵寿县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130127,1301,'高邑县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130128,1301,'深泽县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130129,1301,'赞皇县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130130,1301,'无极县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130131,1301,'平山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130132,1301,'元氏县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130133,1301,'赵县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130181,1301,'辛集市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130182,1301,'藁城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130183,1301,'晋州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130184,1301,'新乐市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130185,1301,'鹿泉市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1302,13,'唐山',now());insert into tbl_province(codeid,parentid,name,createtime) values(130201,1302,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130202,1302,'路南区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130203,1302,'路北区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130204,1302,'古冶区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130205,1302,'开平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130206,1302,'新区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130221,1302,'丰润县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130223,1302,'滦县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130224,1302,'滦南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130225,1302,'乐亭县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130227,1302,'迁西县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130229,1302,'玉田县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130230,1302,'唐海县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130281,1302,'遵化市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130282,1302,'丰南市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130283,1302,'迁安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1303,13,'秦皇岛',now());insert into tbl_province(codeid,parentid,name,createtime) values(130301,1303,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130302,1303,'海港区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130303,1303,'山海关区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130304,1303,'北戴河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130321,1303,'青龙满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130322,1303,'昌黎县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130323,1303,'抚宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130324,1303,'卢龙县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1304,13,'邯郸',now());insert into tbl_province(codeid,parentid,name,createtime) values(130401,1304,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130402,1304,'邯山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130403,1304,'丛台区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130404,1304,'复兴区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130406,1304,'峰峰矿区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130421,1304,'邯郸县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130423,1304,'临漳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130424,1304,'成安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130425,1304,'大名县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130426,1304,'涉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130427,1304,'磁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130428,1304,'肥乡县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130429,1304,'永年县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130430,1304,'邱县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130431,1304,'鸡泽县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130432,1304,'广平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130433,1304,'馆陶县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130434,1304,'魏县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130435,1304,'曲周县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130481,1304,'武安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1305,13,'邢台',now());insert into tbl_province(codeid,parentid,name,createtime) values(130501,1305,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130502,1305,'桥东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130503,1305,'桥西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130521,1305,'邢台县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130522,1305,'临城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130523,1305,'内丘县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130524,1305,'柏乡县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130525,1305,'隆尧县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130526,1305,'任县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130527,1305,'南和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130528,1305,'宁晋县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130529,1305,'巨鹿县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130530,1305,'新河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130531,1305,'广宗县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130532,1305,'平乡县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130533,1305,'威县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130534,1305,'清河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130535,1305,'临西县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130581,1305,'南宫市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130582,1305,'沙河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1306,13,'保定',now());insert into tbl_province(codeid,parentid,name,createtime) values(130601,1306,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130602,1306,'新市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130603,1306,'北市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130604,1306,'南市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130621,1306,'满城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130622,1306,'清苑县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130623,1306,'涞水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130624,1306,'阜平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130625,1306,'徐水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130626,1306,'定兴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130627,1306,'唐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130628,1306,'高阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130629,1306,'容城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130630,1306,'涞源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130631,1306,'望都县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130632,1306,'安新县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130633,1306,'易县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130634,1306,'曲阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130635,1306,'蠡县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130636,1306,'顺平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130637,1306,'博野县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130638,1306,'雄县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130681,1306,'涿州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130682,1306,'定州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130683,1306,'安国市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130684,1306,'高碑店市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1307,13,'张家口',now());insert into tbl_province(codeid,parentid,name,createtime) values(130701,1307,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130702,1307,'桥东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130703,1307,'桥西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130705,1307,'宣化区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130706,1307,'下花园区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130721,1307,'宣化县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130722,1307,'张北县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130723,1307,'康保县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130724,1307,'沽源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130725,1307,'尚义县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130726,1307,'蔚县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130727,1307,'阳原县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130728,1307,'怀安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130729,1307,'万全县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130730,1307,'怀来县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130731,1307,'涿鹿县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130732,1307,'赤城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130733,1307,'崇礼县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1308,13,'承德',now());insert into tbl_province(codeid,parentid,name,createtime) values(130801,1308,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130802,1308,'双桥区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130803,1308,'双滦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130804,1308,'鹰手营子矿区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130821,1308,'承德县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130822,1308,'兴隆县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130823,1308,'平泉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130824,1308,'滦平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130825,1308,'隆化县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130826,1308,'丰宁满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130827,1308,'宽城满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130828,1308,'围场满族蒙古族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1309,13,'沧州',now());insert into tbl_province(codeid,parentid,name,createtime) values(130901,1309,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130902,1309,'新华区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130903,1309,'运河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(130921,1309,'沧县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130922,1309,'青县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130923,1309,'东光县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130924,1309,'海兴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130925,1309,'盐山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130926,1309,'肃宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130927,1309,'南皮县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130928,1309,'吴桥县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130929,1309,'献县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130930,1309,'孟村回族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(130981,1309,'泊头市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130982,1309,'任丘市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130983,1309,'黄骅市',now());insert into tbl_province(codeid,parentid,name,createtime) values(130984,1309,'河间市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1310,13,'廊坊',now());insert into tbl_province(codeid,parentid,name,createtime) values(131001,1310,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(131002,1310,'安次区',now());insert into tbl_province(codeid,parentid,name,createtime) values(131003,1310,'廊坊市广阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(131022,1310,'固安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131023,1310,'永清县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131024,1310,'香河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131025,1310,'大城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131026,1310,'文安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131028,1310,'大厂回族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131081,1310,'霸州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(131082,1310,'三河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1311,13,'衡水',now());insert into tbl_province(codeid,parentid,name,createtime) values(131101,1311,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(131102,1311,'桃城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(131121,1311,'枣强县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131122,1311,'武邑县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131123,1311,'武强县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131124,1311,'饶阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131125,1311,'安平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131126,1311,'故城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131127,1311,'景县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131128,1311,'阜城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(131181,1311,'冀州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(131182,1311,'深州市',now());
insert into tbl_province(codeid,parentid,name,createtime) values(14,0,'山西',now());insert into tbl_province(codeid,parentid,name,createtime) values(1401,14,'太原',now());insert into tbl_province(codeid,parentid,name,createtime) values(140101,1401,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140105,1401,'小店区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140106,1401,'迎泽区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140107,1401,'杏花岭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140108,1401,'尖草坪区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140109,1401,'万柏林区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140110,1401,'晋源区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140121,1401,'清徐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140122,1401,'阳曲县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140123,1401,'娄烦县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140181,1401,'古交市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1402,14,'大同',now());insert into tbl_province(codeid,parentid,name,createtime) values(140201,1402,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140202,1402,'城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140203,1402,'矿区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140211,1402,'南郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140212,1402,'新荣区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140221,1402,'阳高县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140222,1402,'天镇县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140223,1402,'广灵县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140224,1402,'灵丘县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140225,1402,'浑源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140226,1402,'左云县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140227,1402,'大同县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1403,14,'阳泉',now());insert into tbl_province(codeid,parentid,name,createtime) values(140301,1403,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140302,1403,'城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140303,1403,'矿区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140311,1403,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140321,1403,'平定县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140322,1403,'盂县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1404,14,'长治',now());insert into tbl_province(codeid,parentid,name,createtime) values(140401,1404,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140402,1404,'城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140411,1404,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140421,1404,'长治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140423,1404,'襄垣县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140424,1404,'屯留县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140425,1404,'平顺县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140426,1404,'黎城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140427,1404,'壶关县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140428,1404,'长子县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140429,1404,'武乡县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140430,1404,'沁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140431,1404,'沁源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140481,1404,'潞城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1405,14,'晋城',now());insert into tbl_province(codeid,parentid,name,createtime) values(140501,1405,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140502,1405,'城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140521,1405,'沁水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140522,1405,'阳城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140524,1405,'陵川县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140525,1405,'泽州县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140581,1405,'高平市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1406,14,'朔州',now());insert into tbl_province(codeid,parentid,name,createtime) values(140601,1406,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140602,1406,'朔城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140603,1406,'平鲁区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140621,1406,'山阴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140622,1406,'应县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140623,1406,'右玉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140624,1406,'怀仁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1407,14,'晋中',now());insert into tbl_province(codeid,parentid,name,createtime) values(140701,1407,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140702,1407,'榆次区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140721,1407,'榆社县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140722,1407,'左权县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140723,1407,'和顺县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140724,1407,'昔阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140725,1407,'寿阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140726,1407,'太谷县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140727,1407,'祁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140728,1407,'平遥县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140729,1407,'灵石县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140781,1407,'介休市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1408,14,'运城',now());insert into tbl_province(codeid,parentid,name,createtime) values(140801,1408,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140802,1408,'盐湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140821,1408,'临猗县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140822,1408,'万荣县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140823,1408,'闻喜县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140824,1408,'稷山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140825,1408,'新绛县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140826,1408,'绛县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140827,1408,'垣曲县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140828,1408,'夏县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140829,1408,'平陆县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140830,1408,'芮城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140881,1408,'永济市',now());insert into tbl_province(codeid,parentid,name,createtime) values(140882,1408,'河津市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1409,14,'忻州',now());insert into tbl_province(codeid,parentid,name,createtime) values(140901,1409,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140902,1409,'忻府区',now());insert into tbl_province(codeid,parentid,name,createtime) values(140921,1409,'定襄县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140922,1409,'五台县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140923,1409,'代县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140924,1409,'繁峙县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140925,1409,'宁武县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140926,1409,'静乐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140927,1409,'神池县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140928,1409,'五寨县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140929,1409,'岢岚县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140930,1409,'河曲县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140931,1409,'保德县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140932,1409,'偏关县',now());insert into tbl_province(codeid,parentid,name,createtime) values(140981,1409,'原平市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1410,14,'临汾',now());insert into tbl_province(codeid,parentid,name,createtime) values(141001,1410,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(141002,1410,'尧都区',now());insert into tbl_province(codeid,parentid,name,createtime) values(141021,1410,'曲沃县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141022,1410,'翼城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141023,1410,'襄汾县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141024,1410,'洪洞县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141025,1410,'古县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141026,1410,'安泽县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141027,1410,'浮山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141028,1410,'吉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141029,1410,'乡宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141030,1410,'大宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141031,1410,'隰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141032,1410,'永和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141033,1410,'蒲县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141034,1410,'汾西县',now());insert into tbl_province(codeid,parentid,name,createtime) values(141081,1410,'侯马市',now());insert into tbl_province(codeid,parentid,name,createtime) values(141082,1410,'霍州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1423,14,'吕梁地区',now());insert into tbl_province(codeid,parentid,name,createtime) values(142301,1423,'孝义市',now());insert into tbl_province(codeid,parentid,name,createtime) values(142302,1423,'离石市',now());insert into tbl_province(codeid,parentid,name,createtime) values(142303,1423,'汾阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(142322,1423,'文水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142323,1423,'交城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142325,1423,'兴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142326,1423,'临县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142327,1423,'柳林县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142328,1423,'石楼县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142329,1423,'岚县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142330,1423,'方山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142332,1423,'中阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(142333,1423,'交口县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(15,0,'内蒙古',now());insert into tbl_province(codeid,parentid,name,createtime) values(1501,15,'呼和浩特',now());insert into tbl_province(codeid,parentid,name,createtime) values(150101,1501,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150102,1501,'新城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150103,1501,'回民区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150104,1501,'玉泉区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150105,1501,'赛罕区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150121,1501,'土默特左旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150122,1501,'托克托县',now());insert into tbl_province(codeid,parentid,name,createtime) values(150123,1501,'和林格尔县',now());insert into tbl_province(codeid,parentid,name,createtime) values(150124,1501,'清水河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(150125,1501,'武川县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1502,15,'包头',now());insert into tbl_province(codeid,parentid,name,createtime) values(150201,1502,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150202,1502,'东河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150203,1502,'昆都伦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150204,1502,'青山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150205,1502,'石拐区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150206,1502,'白云矿区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150207,1502,'九原区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150221,1502,'土默特右旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150222,1502,'固阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(150223,1502,'达尔罕茂明安联合旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(1503,15,'乌海',now());insert into tbl_province(codeid,parentid,name,createtime) values(150301,1503,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150302,1503,'海勃湾区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150303,1503,'海南区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150304,1503,'乌达区',now());insert into tbl_province(codeid,parentid,name,createtime) values(1504,15,'赤峰',now());insert into tbl_province(codeid,parentid,name,createtime) values(150401,1504,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150402,1504,'红山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150403,1504,'元宝山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150404,1504,'松山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150421,1504,'阿鲁科尔沁旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150422,1504,'巴林左旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150423,1504,'巴林右旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150424,1504,'林西县',now());insert into tbl_province(codeid,parentid,name,createtime) values(150425,1504,'克什克腾旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150426,1504,'翁牛特旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150428,1504,'喀喇沁旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150429,1504,'宁城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(150430,1504,'敖汉旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(1505,15,'通辽',now());insert into tbl_province(codeid,parentid,name,createtime) values(150501,1505,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150502,1505,'科尔沁区',now());insert into tbl_province(codeid,parentid,name,createtime) values(150521,1505,'科尔沁左翼中旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150522,1505,'科尔沁左翼后旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150523,1505,'开鲁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(150524,1505,'库伦旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150525,1505,'奈曼旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150526,1505,'扎鲁特旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(150581,1505,'霍林郭勒市',now());insert into tbl_province(codeid,parentid,name,createtime) values(1521,15,'呼伦贝尔盟',now());insert into tbl_province(codeid,parentid,name,createtime) values(152101,1521,'海拉尔市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152102,1521,'满洲里市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152103,1521,'扎兰屯市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152104,1521,'牙克石市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152105,1521,'根河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152106,1521,'额尔古纳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152122,1521,'阿荣旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152123,1521,'莫力达瓦达斡尔族自治',now());insert into tbl_province(codeid,parentid,name,createtime) values(152127,1521,'鄂伦春自治旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152128,1521,'鄂温克族自治旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152129,1521,'新巴尔虎右旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152130,1521,'新巴尔虎左旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152131,1521,'陈巴尔虎旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(1522,15,'兴安盟',now());insert into tbl_province(codeid,parentid,name,createtime) values(152201,1522,'乌兰浩特市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152202,1522,'阿尔山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152221,1522,'科尔沁右翼前旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152222,1522,'科尔沁右翼中旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152223,1522,'扎赉特旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152224,1522,'突泉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1525,15,'锡林郭勒盟',now());insert into tbl_province(codeid,parentid,name,createtime) values(152501,1525,'二连浩特市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152502,1525,'锡林浩特市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152522,1525,'阿巴嘎旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152523,1525,'苏尼特左旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152524,1525,'苏尼特右旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152525,1525,'东乌珠穆沁旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152526,1525,'西乌珠穆沁旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152527,1525,'太仆寺旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152528,1525,'镶黄旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152529,1525,'正镶白旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152530,1525,'正蓝旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152531,1525,'多伦县',now());insert into tbl_province(codeid,parentid,name,createtime) values(1526,15,'乌兰察布盟',now());insert into tbl_province(codeid,parentid,name,createtime) values(152601,1526,'集宁市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152602,1526,'丰镇市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152624,1526,'卓资县',now());insert into tbl_province(codeid,parentid,name,createtime) values(152625,1526,'化德县',now());insert into tbl_province(codeid,parentid,name,createtime) values(152626,1526,'商都县',now());insert into tbl_province(codeid,parentid,name,createtime) values(152627,1526,'兴和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(152629,1526,'凉城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(152630,1526,'察哈尔右翼前旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152631,1526,'察哈尔右翼中旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152632,1526,'察哈尔右翼后旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152634,1526,'四子王旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(1527,15,'伊克昭盟',now());insert into tbl_province(codeid,parentid,name,createtime) values(152701,1527,'东胜市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152722,1527,'达拉特旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152723,1527,'准格尔旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152724,1527,'鄂托克前旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152725,1527,'鄂托克旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152726,1527,'杭锦旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152727,1527,'乌审旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152728,1527,'伊金霍洛旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(1528,15,'巴彦淖尔盟',now());insert into tbl_province(codeid,parentid,name,createtime) values(152801,1528,'临河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(152822,1528,'五原县',now());insert into tbl_province(codeid,parentid,name,createtime) values(152823,1528,'磴口县',now());insert into tbl_province(codeid,parentid,name,createtime) values(152824,1528,'乌拉特前旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152825,1528,'乌拉特中旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152826,1528,'乌拉特后旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152827,1528,'杭锦后旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(1529,15,'阿拉善盟',now());insert into tbl_province(codeid,parentid,name,createtime) values(152921,1529,'阿拉善左旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152922,1529,'阿拉善右旗',now());insert into tbl_province(codeid,parentid,name,createtime) values(152923,1529,'额济纳旗',now());
insert into tbl_province(codeid,parentid,name,createtime) values(21,0,'辽宁',now());insert into tbl_province(codeid,parentid,name,createtime) values(2101,21,'沈阳',now());insert into tbl_province(codeid,parentid,name,createtime) values(210101,2101,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210102,2101,'和平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210103,2101,'沈河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210104,2101,'大东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210105,2101,'皇姑区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210106,2101,'铁西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210111,2101,'苏家屯区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210112,2101,'东陵区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210113,2101,'新城子区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210114,2101,'于洪区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210122,2101,'辽中县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210123,2101,'康平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210124,2101,'法库县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210181,2101,'新民市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2102,21,'大连',now());insert into tbl_province(codeid,parentid,name,createtime) values(210201,2102,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210202,2102,'中山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210203,2102,'西岗区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210204,2102,'沙河口区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210211,2102,'甘井子区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210212,2102,'旅顺口区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210213,2102,'金州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210224,2102,'长海县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210281,2102,'瓦房店市',now());insert into tbl_province(codeid,parentid,name,createtime) values(210282,2102,'普兰店市',now());insert into tbl_province(codeid,parentid,name,createtime) values(210283,2102,'庄河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2103,21,'鞍山',now());insert into tbl_province(codeid,parentid,name,createtime) values(210301,2103,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210302,2103,'铁东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210303,2103,'铁西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210304,2103,'立山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210311,2103,'千山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210321,2103,'台安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210323,2103,'岫岩满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210381,2103,'海城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2104,21,'抚顺',now());insert into tbl_province(codeid,parentid,name,createtime) values(210401,2104,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210402,2104,'新抚区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210403,2104,'东洲区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210404,2104,'望花区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210411,2104,'顺城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210421,2104,'抚顺县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210422,2104,'新宾满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210423,2104,'清原满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2105,21,'本溪',now());insert into tbl_province(codeid,parentid,name,createtime) values(210501,2105,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210502,2105,'平山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210503,2105,'溪湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210504,2105,'明山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210505,2105,'南芬区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210521,2105,'本溪满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210522,2105,'桓仁满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2106,21,'丹东',now());insert into tbl_province(codeid,parentid,name,createtime) values(210601,2106,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210602,2106,'元宝区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210603,2106,'振兴区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210604,2106,'振安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210624,2106,'宽甸满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210681,2106,'东港市',now());insert into tbl_province(codeid,parentid,name,createtime) values(210682,2106,'凤城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2107,21,'锦州',now());insert into tbl_province(codeid,parentid,name,createtime) values(210701,2107,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210702,2107,'古塔区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210703,2107,'凌河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210711,2107,'太和区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210726,2107,'黑山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210727,2107,'义县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210781,2107,'凌海市',now());insert into tbl_province(codeid,parentid,name,createtime) values(210782,2107,'北宁市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2108,21,'营口',now());insert into tbl_province(codeid,parentid,name,createtime) values(210801,2108,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210802,2108,'站前区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210803,2108,'西市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210804,2108,'鲅鱼圈区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210811,2108,'老边区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210881,2108,'盖州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(210882,2108,'大石桥市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2109,21,'阜新',now());insert into tbl_province(codeid,parentid,name,createtime) values(210901,2109,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210902,2109,'海州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210903,2109,'新邱区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210904,2109,'太平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210905,2109,'清河门区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210911,2109,'细河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(210921,2109,'阜新蒙古族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(210922,2109,'彰武县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2110,21,'辽阳',now());insert into tbl_province(codeid,parentid,name,createtime) values(211001,2110,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211002,2110,'白塔区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211003,2110,'文圣区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211004,2110,'宏伟区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211005,2110,'弓长岭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211011,2110,'太子河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211021,2110,'辽阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211081,2110,'灯塔市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2111,21,'盘锦',now());insert into tbl_province(codeid,parentid,name,createtime) values(211101,2111,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211102,2111,'双台子区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211103,2111,'兴隆台区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211121,2111,'大洼县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211122,2111,'盘山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2112,21,'铁岭',now());insert into tbl_province(codeid,parentid,name,createtime) values(211201,2112,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211202,2112,'银州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211204,2112,'清河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211221,2112,'铁岭县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211223,2112,'西丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211224,2112,'昌图县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211281,2112,'铁法市',now());insert into tbl_province(codeid,parentid,name,createtime) values(211282,2112,'开原市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2113,21,'朝阳',now());insert into tbl_province(codeid,parentid,name,createtime) values(211301,2113,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211302,2113,'双塔区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211303,2113,'龙城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211321,2113,'朝阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211322,2113,'建平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211324,2113,'喀喇沁左翼蒙古族自治',now());insert into tbl_province(codeid,parentid,name,createtime) values(211381,2113,'北票市',now());insert into tbl_province(codeid,parentid,name,createtime) values(211382,2113,'凌源市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2114,21,'葫芦岛',now());insert into tbl_province(codeid,parentid,name,createtime) values(211401,2114,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211402,2114,'连山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211403,2114,'龙港区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211404,2114,'南票区',now());insert into tbl_province(codeid,parentid,name,createtime) values(211421,2114,'绥中县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211422,2114,'建昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(211481,2114,'兴城市',now());
insert into tbl_province(codeid,parentid,name,createtime) values(22,0,'吉林',now());insert into tbl_province(codeid,parentid,name,createtime) values(2201,22,'长春',now());insert into tbl_province(codeid,parentid,name,createtime) values(220101,2201,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220102,2201,'南关区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220103,2201,'宽城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220104,2201,'朝阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220105,2201,'二道区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220106,2201,'绿园区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220112,2201,'双阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220122,2201,'农安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220181,2201,'九台市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220182,2201,'榆树市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220183,2201,'德惠市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2202,22,'吉林',now());insert into tbl_province(codeid,parentid,name,createtime) values(220201,2202,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220202,2202,'昌邑区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220203,2202,'龙潭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220204,2202,'船营区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220211,2202,'丰满区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220221,2202,'永吉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220281,2202,'蛟河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220282,2202,'桦甸市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220283,2202,'舒兰市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220284,2202,'磐石市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2203,22,'四平',now());insert into tbl_province(codeid,parentid,name,createtime) values(220301,2203,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220302,2203,'铁西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220303,2203,'铁东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220322,2203,'梨树县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220323,2203,'伊通满族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220381,2203,'公主岭市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220382,2203,'双辽市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2204,22,'辽源',now());insert into tbl_province(codeid,parentid,name,createtime) values(220401,2204,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220402,2204,'龙山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220403,2204,'西安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220421,2204,'东丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220422,2204,'东辽县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2205,22,'通化',now());insert into tbl_province(codeid,parentid,name,createtime) values(220501,2205,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220502,2205,'东昌区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220503,2205,'二道江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220521,2205,'通化县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220523,2205,'辉南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220524,2205,'柳河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220581,2205,'梅河口市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220582,2205,'集安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2206,22,'白山',now());insert into tbl_province(codeid,parentid,name,createtime) values(220601,2206,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220602,2206,'八道江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220621,2206,'抚松县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220622,2206,'靖宇县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220623,2206,'长白朝鲜族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220625,2206,'江源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220681,2206,'临江市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2207,22,'松原',now());insert into tbl_province(codeid,parentid,name,createtime) values(220701,2207,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220702,2207,'宁江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220721,2207,'前郭尔罗斯蒙古族自治',now());insert into tbl_province(codeid,parentid,name,createtime) values(220722,2207,'长岭县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220723,2207,'乾安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220724,2207,'扶余县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2208,22,'白城',now());insert into tbl_province(codeid,parentid,name,createtime) values(220801,2208,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220802,2208,'洮北区',now());insert into tbl_province(codeid,parentid,name,createtime) values(220821,2208,'镇赉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220822,2208,'通榆县',now());insert into tbl_province(codeid,parentid,name,createtime) values(220881,2208,'洮南市',now());insert into tbl_province(codeid,parentid,name,createtime) values(220882,2208,'大安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2224,22,'延边朝鲜族自治州',now());insert into tbl_province(codeid,parentid,name,createtime) values(222401,2224,'延吉市',now());insert into tbl_province(codeid,parentid,name,createtime) values(222402,2224,'图们市',now());insert into tbl_province(codeid,parentid,name,createtime) values(222403,2224,'敦化市',now());insert into tbl_province(codeid,parentid,name,createtime) values(222404,2224,'珲春市',now());insert into tbl_province(codeid,parentid,name,createtime) values(222405,2224,'龙井市',now());insert into tbl_province(codeid,parentid,name,createtime) values(222406,2224,'和龙市',now());insert into tbl_province(codeid,parentid,name,createtime) values(222424,2224,'汪清县',now());insert into tbl_province(codeid,parentid,name,createtime) values(222426,2224,'安图县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(23,0,'黑龙江',now());insert into tbl_province(codeid,parentid,name,createtime) values(2301,23,'哈尔滨',now());insert into tbl_province(codeid,parentid,name,createtime) values(230101,2301,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230102,2301,'道里区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230103,2301,'南岗区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230104,2301,'道外区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230105,2301,'太平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230106,2301,'香坊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230107,2301,'动力区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230108,2301,'平房区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230121,2301,'呼兰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230123,2301,'依兰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230124,2301,'方正县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230125,2301,'宾县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230126,2301,'巴彦县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230127,2301,'木兰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230128,2301,'通河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230129,2301,'延寿县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230181,2301,'阿城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(230182,2301,'双城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(230183,2301,'尚志市',now());insert into tbl_province(codeid,parentid,name,createtime) values(230184,2301,'五常市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2302,23,'齐齐哈尔',now());insert into tbl_province(codeid,parentid,name,createtime) values(230201,2302,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230202,2302,'龙沙区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230203,2302,'建华区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230204,2302,'铁锋区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230205,2302,'昂昂溪区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230206,2302,'富拉尔基区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230207,2302,'碾子山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230208,2302,'梅里斯达斡尔族区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230221,2302,'龙江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230223,2302,'依安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230224,2302,'泰来县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230225,2302,'甘南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230227,2302,'富裕县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230229,2302,'克山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230230,2302,'克东县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230231,2302,'拜泉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230281,2302,'讷河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2303,23,'鸡西',now());insert into tbl_province(codeid,parentid,name,createtime) values(230301,2303,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230302,2303,'鸡冠区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230303,2303,'恒山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230304,2303,'滴道区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230305,2303,'梨树区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230306,2303,'城子河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230307,2303,'麻山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230321,2303,'鸡东县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230381,2303,'虎林市',now());insert into tbl_province(codeid,parentid,name,createtime) values(230382,2303,'密山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2304,23,'鹤岗',now());insert into tbl_province(codeid,parentid,name,createtime) values(230401,2304,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230402,2304,'向阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230403,2304,'工农区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230404,2304,'南山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230405,2304,'兴安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230406,2304,'东山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230407,2304,'兴山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230421,2304,'萝北县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230422,2304,'绥滨县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2305,23,'双鸭山',now());insert into tbl_province(codeid,parentid,name,createtime) values(230501,2305,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230502,2305,'尖山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230503,2305,'岭东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230505,2305,'四方台区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230506,2305,'宝山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230521,2305,'集贤县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230522,2305,'友谊县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230523,2305,'宝清县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230524,2305,'饶河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2306,23,'大庆',now());insert into tbl_province(codeid,parentid,name,createtime) values(230601,2306,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230602,2306,'萨尔图区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230603,2306,'龙凤区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230604,2306,'让胡路区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230605,2306,'红岗区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230606,2306,'大同区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230621,2306,'肇州县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230622,2306,'肇源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230623,2306,'林甸县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230624,2306,'杜尔伯特蒙古族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2307,23,'伊春',now());insert into tbl_province(codeid,parentid,name,createtime) values(230701,2307,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230702,2307,'伊春区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230703,2307,'南岔区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230704,2307,'友好区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230705,2307,'西林区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230706,2307,'翠峦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230707,2307,'新青区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230708,2307,'美溪区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230709,2307,'金山屯区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230710,2307,'五营区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230711,2307,'乌马河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230712,2307,'汤旺河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230713,2307,'带岭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230714,2307,'乌伊岭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230715,2307,'红星区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230716,2307,'上甘岭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230722,2307,'嘉荫县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230781,2307,'铁力市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2308,23,'佳木斯',now());insert into tbl_province(codeid,parentid,name,createtime) values(230801,2308,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230802,2308,'永红区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230803,2308,'向阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230804,2308,'前进区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230805,2308,'东风区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230811,2308,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230822,2308,'桦南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230826,2308,'桦川县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230828,2308,'汤原县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230833,2308,'抚远县',now());insert into tbl_province(codeid,parentid,name,createtime) values(230881,2308,'同江市',now());insert into tbl_province(codeid,parentid,name,createtime) values(230882,2308,'富锦市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2309,23,'七台河',now());insert into tbl_province(codeid,parentid,name,createtime) values(230901,2309,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230902,2309,'新兴区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230903,2309,'桃山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230904,2309,'茄子河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(230921,2309,'勃利县',now());insert into tbl_province(codeid,parentid,name,createtime) values(2310,23,'牡丹江',now());insert into tbl_province(codeid,parentid,name,createtime) values(231001,2310,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231002,2310,'东安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231003,2310,'阳明区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231004,2310,'爱民区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231005,2310,'西安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231024,2310,'东宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231025,2310,'林口县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231081,2310,'绥芬河市',now());insert into tbl_province(codeid,parentid,name,createtime) values(231083,2310,'海林市',now());insert into tbl_province(codeid,parentid,name,createtime) values(231084,2310,'宁安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(231085,2310,'穆棱市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2311,23,'黑河',now());insert into tbl_province(codeid,parentid,name,createtime) values(231101,2311,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231102,2311,'爱辉区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231121,2311,'嫩江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231123,2311,'逊克县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231124,2311,'孙吴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231181,2311,'北安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(231182,2311,'五大连池市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2312,23,'绥化',now());insert into tbl_province(codeid,parentid,name,createtime) values(231201,2312,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231202,2312,'北林区',now());insert into tbl_province(codeid,parentid,name,createtime) values(231221,2312,'望奎县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231222,2312,'兰西县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231223,2312,'青冈县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231224,2312,'庆安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231225,2312,'明水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231226,2312,'绥棱县',now());insert into tbl_province(codeid,parentid,name,createtime) values(231281,2312,'安达市',now());insert into tbl_province(codeid,parentid,name,createtime) values(231282,2312,'肇东市',now());insert into tbl_province(codeid,parentid,name,createtime) values(231283,2312,'海伦市',now());insert into tbl_province(codeid,parentid,name,createtime) values(2327,23,'大兴安岭地区',now());insert into tbl_province(codeid,parentid,name,createtime) values(232721,2327,'呼玛县',now());insert into tbl_province(codeid,parentid,name,createtime) values(232722,2327,'塔河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(232723,2327,'漠河县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(31,0,'上海',now());insert into tbl_province(codeid,parentid,name,createtime) values(3101,31,'上海市辖',now());insert into tbl_province(codeid,parentid,name,createtime) values(310101,3101,'黄浦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310103,3101,'卢湾区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310104,3101,'徐汇区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310105,3101,'长宁区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310106,3101,'静安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310107,3101,'普陀区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310108,3101,'闸北区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310109,3101,'虹口区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310110,3101,'杨浦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310112,3101,'闵行区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310113,3101,'宝山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310114,3101,'嘉定区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310115,3101,'浦东新区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310116,3101,'金山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310117,3101,'松江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(310118,3101,'青浦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(3102,31,'上海县辖',now());insert into tbl_province(codeid,parentid,name,createtime) values(310225,3102,'南汇县',now());insert into tbl_province(codeid,parentid,name,createtime) values(310226,3102,'奉贤县',now());insert into tbl_province(codeid,parentid,name,createtime) values(310230,3102,'崇明县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(32,0,'江苏',now());insert into tbl_province(codeid,parentid,name,createtime) values(3201,32,'南京',now());insert into tbl_province(codeid,parentid,name,createtime) values(320101,3201,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320102,3201,'玄武区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320103,3201,'白下区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320104,3201,'秦淮区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320105,3201,'建邺区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320106,3201,'鼓楼区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320107,3201,'下关区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320111,3201,'浦口区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320112,3201,'大厂区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320113,3201,'栖霞区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320114,3201,'雨花台区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320115,3201,'江宁区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320122,3201,'江浦县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320123,3201,'六合县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320124,3201,'溧水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320125,3201,'高淳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3202,32,'无锡',now());insert into tbl_province(codeid,parentid,name,createtime) values(320201,3202,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320202,3202,'崇安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320203,3202,'南长区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320204,3202,'北塘区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320205,3202,'锡山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320206,3202,'惠山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320211,3202,'滨湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320281,3202,'江阴市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320282,3202,'宜兴市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3203,32,'徐州',now());insert into tbl_province(codeid,parentid,name,createtime) values(320301,3203,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320302,3203,'鼓楼区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320303,3203,'云龙区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320304,3203,'九里区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320305,3203,'贾汪区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320311,3203,'泉山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320321,3203,'丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320322,3203,'沛县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320323,3203,'铜山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320324,3203,'睢宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320381,3203,'新沂市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320382,3203,'邳州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3204,32,'常州',now());insert into tbl_province(codeid,parentid,name,createtime) values(320401,3204,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320402,3204,'天宁区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320404,3204,'钟楼区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320405,3204,'戚墅堰区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320411,3204,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320481,3204,'溧阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320482,3204,'金坛市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320483,3204,'武进市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3205,32,'苏州',now());insert into tbl_province(codeid,parentid,name,createtime) values(320501,3205,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320502,3205,'沧浪区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320503,3205,'平江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320504,3205,'金阊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320505,3205,'虎丘区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320506,3205,'吴中区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320507,3205,'相城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320581,3205,'常熟市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320582,3205,'张家港市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320583,3205,'昆山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320584,3205,'吴江市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320585,3205,'太仓市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3206,32,'南通',now());insert into tbl_province(codeid,parentid,name,createtime) values(320601,3206,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320602,3206,'崇川区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320611,3206,'港闸区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320621,3206,'海安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320623,3206,'如东县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320681,3206,'启东市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320682,3206,'如皋市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320683,3206,'通州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320684,3206,'海门市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3207,32,'连云港',now());insert into tbl_province(codeid,parentid,name,createtime) values(320701,3207,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320703,3207,'连云区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320704,3207,'云台区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320705,3207,'新浦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320706,3207,'海州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320721,3207,'赣榆县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320722,3207,'东海县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320723,3207,'灌云县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320724,3207,'灌南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3208,32,'淮安',now());insert into tbl_province(codeid,parentid,name,createtime) values(320801,3208,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320802,3208,'清河区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320803,3208,'楚州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320804,3208,'淮阴区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320811,3208,'清浦区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320826,3208,'涟水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320829,3208,'洪泽县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320830,3208,'盱眙县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320831,3208,'金湖县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3209,32,'盐城',now());insert into tbl_province(codeid,parentid,name,createtime) values(320901,3209,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320902,3209,'城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(320921,3209,'响水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320922,3209,'滨海县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320923,3209,'阜宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320924,3209,'射阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320925,3209,'建湖县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320928,3209,'盐都县',now());insert into tbl_province(codeid,parentid,name,createtime) values(320981,3209,'东台市',now());insert into tbl_province(codeid,parentid,name,createtime) values(320982,3209,'大丰市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3210,32,'扬州',now());insert into tbl_province(codeid,parentid,name,createtime) values(321001,3210,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321002,3210,'广陵区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321003,3210,'邗江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321011,3210,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321023,3210,'宝应县',now());insert into tbl_province(codeid,parentid,name,createtime) values(321081,3210,'仪征市',now());insert into tbl_province(codeid,parentid,name,createtime) values(321084,3210,'高邮市',now());insert into tbl_province(codeid,parentid,name,createtime) values(321088,3210,'江都市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3211,32,'镇江',now());insert into tbl_province(codeid,parentid,name,createtime) values(321101,3211,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321102,3211,'京口区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321111,3211,'润州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321121,3211,'丹徒县',now());insert into tbl_province(codeid,parentid,name,createtime) values(321181,3211,'丹阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(321182,3211,'扬中市',now());insert into tbl_province(codeid,parentid,name,createtime) values(321183,3211,'句容市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3212,32,'泰州',now());insert into tbl_province(codeid,parentid,name,createtime) values(321201,3212,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321202,3212,'海陵区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321203,3212,'高港区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321281,3212,'兴化市',now());insert into tbl_province(codeid,parentid,name,createtime) values(321282,3212,'靖江市',now());insert into tbl_province(codeid,parentid,name,createtime) values(321283,3212,'泰兴市',now());insert into tbl_province(codeid,parentid,name,createtime) values(321284,3212,'姜堰市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3213,32,'宿迁',now());insert into tbl_province(codeid,parentid,name,createtime) values(321301,3213,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321302,3213,'宿城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(321321,3213,'宿豫县',now());insert into tbl_province(codeid,parentid,name,createtime) values(321322,3213,'沭阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(321323,3213,'泗阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(321324,3213,'泗洪县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(33,0,'浙江',now());insert into tbl_province(codeid,parentid,name,createtime) values(3301,33,'杭州',now());insert into tbl_province(codeid,parentid,name,createtime) values(330101,3301,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330102,3301,'上城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330103,3301,'下城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330104,3301,'江干区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330105,3301,'拱墅区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330106,3301,'西湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330108,3301,'滨江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330122,3301,'桐庐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330127,3301,'淳安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330181,3301,'萧山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330182,3301,'建德市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330183,3301,'富阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330184,3301,'余杭市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330185,3301,'临安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3302,33,'宁波',now());insert into tbl_province(codeid,parentid,name,createtime) values(330201,3302,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330203,3302,'海曙区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330204,3302,'江东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330205,3302,'江北区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330206,3302,'北仑区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330211,3302,'镇海区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330225,3302,'象山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330226,3302,'宁海县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330227,3302,'鄞县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330281,3302,'余姚市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330282,3302,'慈溪市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330283,3302,'奉化市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3303,33,'温州',now());insert into tbl_province(codeid,parentid,name,createtime) values(330301,3303,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330302,3303,'鹿城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330303,3303,'龙湾区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330304,3303,'瓯海区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330322,3303,'洞头县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330324,3303,'永嘉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330326,3303,'平阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330327,3303,'苍南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330328,3303,'文成县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330329,3303,'泰顺县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330381,3303,'瑞安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330382,3303,'乐清市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3304,33,'嘉兴',now());insert into tbl_province(codeid,parentid,name,createtime) values(330401,3304,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330402,3304,'秀城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330411,3304,'秀洲区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330421,3304,'嘉善县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330424,3304,'海盐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330481,3304,'海宁市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330482,3304,'平湖市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330483,3304,'桐乡市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3305,33,'湖州',now());insert into tbl_province(codeid,parentid,name,createtime) values(330501,3305,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330521,3305,'德清县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330522,3305,'长兴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330523,3305,'安吉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3306,33,'绍兴',now());insert into tbl_province(codeid,parentid,name,createtime) values(330601,3306,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330602,3306,'越城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330621,3306,'绍兴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330624,3306,'新昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330681,3306,'诸暨市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330682,3306,'上虞市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330683,3306,'嵊州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3307,33,'金华',now());insert into tbl_province(codeid,parentid,name,createtime) values(330701,3307,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330702,3307,'婺城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330703,3307,'金东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330723,3307,'武义县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330726,3307,'浦江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330727,3307,'磐安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330781,3307,'兰溪市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330782,3307,'义乌市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330783,3307,'东阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(330784,3307,'永康市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3308,33,'衢州',now());insert into tbl_province(codeid,parentid,name,createtime) values(330801,3308,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330802,3308,'柯城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330821,3308,'衢县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330822,3308,'常山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330824,3308,'开化县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330825,3308,'龙游县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330881,3308,'江山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3309,33,'舟山',now());insert into tbl_province(codeid,parentid,name,createtime) values(330901,3309,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330902,3309,'定海区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330903,3309,'普陀区',now());insert into tbl_province(codeid,parentid,name,createtime) values(330921,3309,'岱山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(330922,3309,'嵊泗县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3310,33,'台州',now());insert into tbl_province(codeid,parentid,name,createtime) values(331001,3310,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(331002,3310,'椒江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(331003,3310,'黄岩区',now());insert into tbl_province(codeid,parentid,name,createtime) values(331004,3310,'路桥区',now());insert into tbl_province(codeid,parentid,name,createtime) values(331021,3310,'玉环县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331022,3310,'三门县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331023,3310,'天台县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331024,3310,'仙居县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331081,3310,'温岭市',now());insert into tbl_province(codeid,parentid,name,createtime) values(331082,3310,'临海市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3311,33,'丽水',now());insert into tbl_province(codeid,parentid,name,createtime) values(331101,3311,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(331102,3311,'莲都区',now());insert into tbl_province(codeid,parentid,name,createtime) values(331121,3311,'青田县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331122,3311,'缙云县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331123,3311,'遂昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331124,3311,'松阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331125,3311,'云和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331126,3311,'庆元县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331127,3311,'景宁畲族自治县',now());insert into tbl_province(codeid,parentid,name,createtime) values(331181,3311,'龙泉市',now());
insert into tbl_province(codeid,parentid,name,createtime) values(34,0,'安徽',now());insert into tbl_province(codeid,parentid,name,createtime) values(3401,34,'合肥',now());insert into tbl_province(codeid,parentid,name,createtime) values(340101,3401,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340102,3401,'东市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340103,3401,'中市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340104,3401,'西市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340111,3401,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340121,3401,'长丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340122,3401,'肥东县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340123,3401,'肥西县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3402,34,'芜湖',now());insert into tbl_province(codeid,parentid,name,createtime) values(340201,3402,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340202,3402,'镜湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340203,3402,'马塘区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340204,3402,'新芜区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340207,3402,'鸠江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340221,3402,'芜湖县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340222,3402,'繁昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340223,3402,'南陵县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3403,34,'蚌埠',now());insert into tbl_province(codeid,parentid,name,createtime) values(340301,3403,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340302,3403,'东市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340303,3403,'中市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340304,3403,'西市区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340311,3403,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340321,3403,'怀远县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340322,3403,'五河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340323,3403,'固镇县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3404,34,'淮南',now());insert into tbl_province(codeid,parentid,name,createtime) values(340401,3404,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340402,3404,'大通区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340403,3404,'田家庵区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340404,3404,'谢家集区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340405,3404,'八公山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340406,3404,'潘集区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340421,3404,'凤台县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3405,34,'马鞍山',now());insert into tbl_province(codeid,parentid,name,createtime) values(340501,3405,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340502,3405,'金家庄区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340503,3405,'花山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340504,3405,'雨山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340505,3405,'向山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340521,3405,'当涂县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3406,34,'淮北',now());insert into tbl_province(codeid,parentid,name,createtime) values(340601,3406,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340602,3406,'杜集区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340603,3406,'相山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340604,3406,'烈山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340621,3406,'濉溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3407,34,'铜陵',now());insert into tbl_province(codeid,parentid,name,createtime) values(340701,3407,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340702,3407,'铜官山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340703,3407,'狮子山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340711,3407,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340721,3407,'铜陵县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3408,34,'安庆',now());insert into tbl_province(codeid,parentid,name,createtime) values(340801,3408,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340802,3408,'迎江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340803,3408,'大观区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340811,3408,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(340822,3408,'怀宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340823,3408,'枞阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340824,3408,'潜山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340825,3408,'太湖县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340826,3408,'宿松县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340827,3408,'望江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340828,3408,'岳西县',now());insert into tbl_province(codeid,parentid,name,createtime) values(340881,3408,'桐城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3410,34,'黄山',now());insert into tbl_province(codeid,parentid,name,createtime) values(341001,3410,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341002,3410,'屯溪区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341003,3410,'黄山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341004,3410,'徽州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341021,3410,'歙县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341022,3410,'休宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341023,3410,'黟县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341024,3410,'祁门县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3411,34,'滁州',now());insert into tbl_province(codeid,parentid,name,createtime) values(341101,3411,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341102,3411,'琅琊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341103,3411,'南谯区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341122,3411,'来安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341124,3411,'全椒县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341125,3411,'定远县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341126,3411,'凤阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341181,3411,'天长市',now());insert into tbl_province(codeid,parentid,name,createtime) values(341182,3411,'明光市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3412,34,'阜阳',now());insert into tbl_province(codeid,parentid,name,createtime) values(341201,3412,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341202,3412,'颍州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341203,3412,'颍东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341204,3412,'颍泉区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341221,3412,'临泉县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341222,3412,'太和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341225,3412,'阜南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341226,3412,'颍上县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341282,3412,'界首市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3413,34,'宿州',now());insert into tbl_province(codeid,parentid,name,createtime) values(341301,3413,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341302,3413,'墉桥区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341321,3413,'砀山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341322,3413,'萧县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341323,3413,'灵璧县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341324,3413,'泗县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3414,34,'巢湖',now());insert into tbl_province(codeid,parentid,name,createtime) values(341401,3414,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341402,3414,'居巢区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341421,3414,'庐江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341422,3414,'无为县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341423,3414,'含山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341424,3414,'和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3415,34,'六安',now());insert into tbl_province(codeid,parentid,name,createtime) values(341501,3415,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341502,3415,'金安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341503,3415,'裕安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341521,3415,'寿县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341522,3415,'霍邱县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341523,3415,'舒城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341524,3415,'金寨县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341525,3415,'霍山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3416,34,'亳州',now());insert into tbl_province(codeid,parentid,name,createtime) values(341601,3416,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341602,3416,'谯城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341621,3416,'涡阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341622,3416,'蒙城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341623,3416,'利辛县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3417,34,'池州',now());insert into tbl_province(codeid,parentid,name,createtime) values(341701,3417,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341702,3417,'贵池区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341721,3417,'东至县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341722,3417,'石台县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341723,3417,'青阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3418,34,'宣城',now());insert into tbl_province(codeid,parentid,name,createtime) values(341801,3418,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341802,3418,'宣州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(341821,3418,'郎溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341822,3418,'广德县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341823,3418,'泾县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341824,3418,'绩溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341825,3418,'旌德县',now());insert into tbl_province(codeid,parentid,name,createtime) values(341881,3418,'宁国市',now());
insert into tbl_province(codeid,parentid,name,createtime) values(35,0,'福建',now());insert into tbl_province(codeid,parentid,name,createtime) values(3501,35,'福州',now());insert into tbl_province(codeid,parentid,name,createtime) values(350101,3501,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350102,3501,'鼓楼区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350103,3501,'台江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350104,3501,'仓山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350105,3501,'马尾区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350111,3501,'晋安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350121,3501,'闽侯县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350122,3501,'连江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350123,3501,'罗源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350124,3501,'闽清县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350125,3501,'永泰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350128,3501,'平潭县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350181,3501,'福清市',now());insert into tbl_province(codeid,parentid,name,createtime) values(350182,3501,'长乐市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3502,35,'厦门',now());insert into tbl_province(codeid,parentid,name,createtime) values(350201,3502,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350202,3502,'鼓浪屿区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350203,3502,'思明区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350204,3502,'开元区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350205,3502,'杏林区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350206,3502,'湖里区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350211,3502,'集美区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350212,3502,'同安区',now());insert into tbl_province(codeid,parentid,name,createtime) values(3503,35,'莆田',now());insert into tbl_province(codeid,parentid,name,createtime) values(350301,3503,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350302,3503,'城厢区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350303,3503,'涵江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350321,3503,'莆田县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350322,3503,'仙游县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3504,35,'三明',now());insert into tbl_province(codeid,parentid,name,createtime) values(350401,3504,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350402,3504,'梅列区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350403,3504,'三元区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350421,3504,'明溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350423,3504,'清流县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350424,3504,'宁化县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350425,3504,'大田县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350426,3504,'尤溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350427,3504,'沙县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350428,3504,'将乐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350429,3504,'泰宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350430,3504,'建宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350481,3504,'永安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3505,35,'泉州',now());insert into tbl_province(codeid,parentid,name,createtime) values(350501,3505,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350502,3505,'鲤城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350503,3505,'丰泽区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350504,3505,'洛江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350505,3505,'泉港区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350521,3505,'惠安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350524,3505,'安溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350525,3505,'永春县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350526,3505,'德化县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350527,3505,'金门县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350581,3505,'石狮市',now());insert into tbl_province(codeid,parentid,name,createtime) values(350582,3505,'晋江市',now());insert into tbl_province(codeid,parentid,name,createtime) values(350583,3505,'南安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3506,35,'漳州',now());insert into tbl_province(codeid,parentid,name,createtime) values(350601,3506,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350602,3506,'芗城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350603,3506,'龙文区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350622,3506,'云霄县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350623,3506,'漳浦县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350624,3506,'诏安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350625,3506,'长泰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350626,3506,'东山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350627,3506,'南靖县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350628,3506,'平和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350629,3506,'华安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350681,3506,'龙海市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3507,35,'南平',now());insert into tbl_province(codeid,parentid,name,createtime) values(350701,3507,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350702,3507,'延平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350721,3507,'顺昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350722,3507,'浦城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350723,3507,'光泽县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350724,3507,'松溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350725,3507,'政和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350781,3507,'邵武市',now());insert into tbl_province(codeid,parentid,name,createtime) values(350782,3507,'武夷山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(350783,3507,'建瓯市',now());insert into tbl_province(codeid,parentid,name,createtime) values(350784,3507,'建阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3508,35,'龙岩',now());insert into tbl_province(codeid,parentid,name,createtime) values(350801,3508,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350802,3508,'新罗区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350821,3508,'长汀县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350822,3508,'永定县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350823,3508,'上杭县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350824,3508,'武平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350825,3508,'连城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350881,3508,'漳平市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3509,35,'宁德',now());insert into tbl_province(codeid,parentid,name,createtime) values(350901,3509,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350902,3509,'蕉城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(350921,3509,'霞浦县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350922,3509,'古田县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350923,3509,'屏南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350924,3509,'寿宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350925,3509,'周宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350926,3509,'柘荣县',now());insert into tbl_province(codeid,parentid,name,createtime) values(350981,3509,'福安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(350982,3509,'福鼎市',now());
insert into tbl_province(codeid,parentid,name,createtime) values(36,0,'江西',now());insert into tbl_province(codeid,parentid,name,createtime) values(3601,36,'南昌',now());insert into tbl_province(codeid,parentid,name,createtime) values(360101,3601,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360102,3601,'东湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360103,3601,'西湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360104,3601,'青云谱区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360105,3601,'湾里区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360111,3601,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360121,3601,'南昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360122,3601,'新建县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360123,3601,'安义县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360124,3601,'进贤县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3602,36,'景德镇',now());insert into tbl_province(codeid,parentid,name,createtime) values(360201,3602,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360202,3602,'昌江区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360203,3602,'珠山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360222,3602,'浮梁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360281,3602,'乐平市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3603,36,'萍乡',now());insert into tbl_province(codeid,parentid,name,createtime) values(360301,3603,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360302,3603,'安源区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360313,3603,'湘东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360321,3603,'莲花县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360322,3603,'上栗县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360323,3603,'芦溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3604,36,'九江',now());insert into tbl_province(codeid,parentid,name,createtime) values(360401,3604,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360402,3604,'庐山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360403,3604,'浔阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360421,3604,'九江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360423,3604,'武宁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360424,3604,'修水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360425,3604,'永修县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360426,3604,'德安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360427,3604,'星子县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360428,3604,'都昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360429,3604,'湖口县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360430,3604,'彭泽县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360481,3604,'瑞昌市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3605,36,'新余',now());insert into tbl_province(codeid,parentid,name,createtime) values(360501,3605,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360502,3605,'渝水区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360521,3605,'分宜县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3606,36,'鹰潭',now());insert into tbl_province(codeid,parentid,name,createtime) values(360601,3606,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360602,3606,'月湖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360622,3606,'余江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360681,3606,'贵溪市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3607,36,'赣州',now());insert into tbl_province(codeid,parentid,name,createtime) values(360701,3607,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360702,3607,'章贡区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360721,3607,'赣县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360722,3607,'信丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360723,3607,'大余县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360724,3607,'上犹县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360725,3607,'崇义县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360726,3607,'安远县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360727,3607,'龙南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360728,3607,'定南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360729,3607,'全南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360730,3607,'宁都县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360731,3607,'于都县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360732,3607,'兴国县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360733,3607,'会昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360734,3607,'寻乌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360735,3607,'石城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360781,3607,'瑞金市',now());insert into tbl_province(codeid,parentid,name,createtime) values(360782,3607,'南康市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3608,36,'吉安',now());insert into tbl_province(codeid,parentid,name,createtime) values(360801,3608,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360802,3608,'吉州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360803,3608,'青原区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360821,3608,'吉安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360822,3608,'吉水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360823,3608,'峡江县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360824,3608,'新干县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360825,3608,'永丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360826,3608,'泰和县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360827,3608,'遂川县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360828,3608,'万安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360829,3608,'安福县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360830,3608,'永新县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360881,3608,'井冈山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3609,36,'宜春',now());insert into tbl_province(codeid,parentid,name,createtime) values(360901,3609,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360902,3609,'袁州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(360921,3609,'奉新县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360922,3609,'万载县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360923,3609,'上高县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360924,3609,'宜丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360925,3609,'靖安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360926,3609,'铜鼓县',now());insert into tbl_province(codeid,parentid,name,createtime) values(360981,3609,'丰城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(360982,3609,'樟树市',now());insert into tbl_province(codeid,parentid,name,createtime) values(360983,3609,'高安市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3610,36,'抚州',now());insert into tbl_province(codeid,parentid,name,createtime) values(361001,3610,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(361002,3610,'临川区',now());insert into tbl_province(codeid,parentid,name,createtime) values(361021,3610,'南城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361022,3610,'黎川县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361023,3610,'南丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361024,3610,'崇仁县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361025,3610,'乐安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361026,3610,'宜黄县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361027,3610,'金溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361028,3610,'资溪县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361029,3610,'东乡县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361030,3610,'广昌县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3611,36,'上饶',now());insert into tbl_province(codeid,parentid,name,createtime) values(361101,3611,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(361102,3611,'信州区',now());insert into tbl_province(codeid,parentid,name,createtime) values(361121,3611,'上饶县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361122,3611,'广丰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361123,3611,'玉山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361124,3611,'铅山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361125,3611,'横峰县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361126,3611,'弋阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361127,3611,'余干县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361128,3611,'波阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361129,3611,'万年县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361130,3611,'婺源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(361181,3611,'德兴市',now());
insert into tbl_province(codeid,parentid,name,createtime) values(37,0,'山东',now());insert into tbl_province(codeid,parentid,name,createtime) values(3701,37,'济南',now());insert into tbl_province(codeid,parentid,name,createtime) values(370101,3701,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370102,3701,'历下区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370103,3701,'市中区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370104,3701,'槐荫区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370105,3701,'天桥区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370112,3701,'历城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370123,3701,'长清县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370124,3701,'平阴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370125,3701,'济阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370126,3701,'商河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370181,3701,'章丘市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3702,37,'青岛',now());insert into tbl_province(codeid,parentid,name,createtime) values(370201,3702,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370202,3702,'市南区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370203,3702,'市北区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370205,3702,'四方区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370211,3702,'黄岛区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370212,3702,'崂山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370213,3702,'李沧区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370214,3702,'城阳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370281,3702,'胶州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370282,3702,'即墨市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370283,3702,'平度市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370284,3702,'胶南市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370285,3702,'莱西市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3703,37,'淄博',now());insert into tbl_province(codeid,parentid,name,createtime) values(370301,3703,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370302,3703,'淄川区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370303,3703,'张店区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370304,3703,'博山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370305,3703,'临淄区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370306,3703,'周村区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370321,3703,'桓台县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370322,3703,'高青县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370323,3703,'沂源县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3704,37,'枣庄',now());insert into tbl_province(codeid,parentid,name,createtime) values(370401,3704,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370402,3704,'市中区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370403,3704,'薛城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370404,3704,'峄城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370405,3704,'台儿庄区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370406,3704,'山亭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370481,3704,'滕州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3705,37,'东营',now());insert into tbl_province(codeid,parentid,name,createtime) values(370501,3705,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370502,3705,'东营区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370503,3705,'河口区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370521,3705,'垦利县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370522,3705,'利津县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370523,3705,'广饶县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3706,37,'烟台',now());insert into tbl_province(codeid,parentid,name,createtime) values(370601,3706,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370602,3706,'芝罘区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370611,3706,'福山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370612,3706,'牟平区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370613,3706,'莱山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370634,3706,'长岛县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370681,3706,'龙口市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370682,3706,'莱阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370683,3706,'莱州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370684,3706,'蓬莱市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370685,3706,'招远市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370686,3706,'栖霞市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370687,3706,'海阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3707,37,'潍坊',now());insert into tbl_province(codeid,parentid,name,createtime) values(370701,3707,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370702,3707,'潍城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370703,3707,'寒亭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370704,3707,'坊子区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370705,3707,'奎文区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370724,3707,'临朐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370725,3707,'昌乐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370781,3707,'青州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370782,3707,'诸城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370783,3707,'寿光市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370784,3707,'安丘市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370785,3707,'高密市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370786,3707,'昌邑市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3708,37,'济宁',now());insert into tbl_province(codeid,parentid,name,createtime) values(370801,3708,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370802,3708,'市中区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370811,3708,'任城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370826,3708,'微山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370827,3708,'鱼台县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370828,3708,'金乡县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370829,3708,'嘉祥县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370830,3708,'汶上县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370831,3708,'泗水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370832,3708,'梁山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370881,3708,'曲阜市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370882,3708,'兖州市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370883,3708,'邹城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3709,37,'泰安',now());insert into tbl_province(codeid,parentid,name,createtime) values(370901,3709,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370902,3709,'泰山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370903,3709,'岱岳区',now());insert into tbl_province(codeid,parentid,name,createtime) values(370921,3709,'宁阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370923,3709,'东平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(370982,3709,'新泰市',now());insert into tbl_province(codeid,parentid,name,createtime) values(370983,3709,'肥城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3710,37,'威海',now());insert into tbl_province(codeid,parentid,name,createtime) values(371001,3710,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371002,3710,'环翠区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371081,3710,'文登市',now());insert into tbl_province(codeid,parentid,name,createtime) values(371082,3710,'荣成市',now());insert into tbl_province(codeid,parentid,name,createtime) values(371083,3710,'乳山市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3711,37,'日照',now());insert into tbl_province(codeid,parentid,name,createtime) values(371101,3711,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371102,3711,'东港区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371121,3711,'五莲县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371122,3711,'莒县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3712,37,'莱芜',now());insert into tbl_province(codeid,parentid,name,createtime) values(371201,3712,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371202,3712,'莱城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371203,3712,'钢城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(3713,37,'临沂',now());insert into tbl_province(codeid,parentid,name,createtime) values(371301,3713,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371302,3713,'兰山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371311,3713,'罗庄区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371312,3713,'河东区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371321,3713,'沂南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371322,3713,'郯城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371323,3713,'沂水县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371324,3713,'苍山县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371325,3713,'费县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371326,3713,'平邑县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371327,3713,'莒南县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371328,3713,'蒙阴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371329,3713,'临沭县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3714,37,'德州',now());insert into tbl_province(codeid,parentid,name,createtime) values(371401,3714,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371402,3714,'德城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371421,3714,'陵县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371422,3714,'宁津县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371423,3714,'庆云县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371424,3714,'临邑县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371425,3714,'齐河县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371426,3714,'平原县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371427,3714,'夏津县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371428,3714,'武城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371481,3714,'乐陵市',now());insert into tbl_province(codeid,parentid,name,createtime) values(371482,3714,'禹城市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3715,37,'聊城',now());insert into tbl_province(codeid,parentid,name,createtime) values(371501,3715,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371502,3715,'东昌府区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371521,3715,'阳谷县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371522,3715,'莘县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371523,3715,'茌平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371524,3715,'东阿县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371525,3715,'冠县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371526,3715,'高唐县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371581,3715,'临清市',now());insert into tbl_province(codeid,parentid,name,createtime) values(3716,37,'滨州',now());insert into tbl_province(codeid,parentid,name,createtime) values(371601,3716,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371603,3716,'滨城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371621,3716,'惠民县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371622,3716,'阳信县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371623,3716,'无棣县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371624,3716,'沾化县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371625,3716,'博兴县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371626,3716,'邹平县',now());insert into tbl_province(codeid,parentid,name,createtime) values(3717,37,'菏泽',now());insert into tbl_province(codeid,parentid,name,createtime) values(371701,3717,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371702,3717,'牡丹区',now());insert into tbl_province(codeid,parentid,name,createtime) values(371721,3717,'曹县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371722,3717,'单县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371723,3717,'成武县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371724,3717,'巨野县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371725,3717,'郓城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371726,3717,'鄄城县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371727,3717,'定陶县',now());insert into tbl_province(codeid,parentid,name,createtime) values(371728,3717,'东明县',now());
insert into tbl_province(codeid,parentid,name,createtime) values(41,0,'河南',now());insert into tbl_province(codeid,parentid,name,createtime) values(4101,41,'郑州',now());insert into tbl_province(codeid,parentid,name,createtime) values(410101,4101,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410102,4101,'中原区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410103,4101,'二七区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410104,4101,'管城回族区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410105,4101,'金水区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410106,4101,'上街区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410108,4101,'邙山区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410122,4101,'中牟县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410181,4101,'巩义市',now());insert into tbl_province(codeid,parentid,name,createtime) values(410182,4101,'荥阳市',now());insert into tbl_province(codeid,parentid,name,createtime) values(410183,4101,'新密市',now());insert into tbl_province(codeid,parentid,name,createtime) values(410184,4101,'新郑市',now());insert into tbl_province(codeid,parentid,name,createtime) values(410185,4101,'登封市',now());insert into tbl_province(codeid,parentid,name,createtime) values(4102,41,'开封',now());insert into tbl_province(codeid,parentid,name,createtime) values(410201,4102,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410202,4102,'龙亭区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410203,4102,'顺河回族区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410204,4102,'鼓楼区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410205,4102,'南关区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410211,4102,'郊区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410221,4102,'杞县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410222,4102,'通许县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410223,4102,'尉氏县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410224,4102,'开封县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410225,4102,'兰考县',now());insert into tbl_province(codeid,parentid,name,createtime) values(4103,41,'洛阳',now());insert into tbl_province(codeid,parentid,name,createtime) values(410301,4103,'市辖区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410302,4103,'老城区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410303,4103,'西工区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410304,4103,'廛河回族区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410305,4103,'涧西区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410306,4103,'吉利区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410307,4103,'洛龙区',now());insert into tbl_province(codeid,parentid,name,createtime) values(410322,4103,'孟津县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410323,4103,'新安县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410324,4103,'栾川县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410325,4103,'嵩县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410326,4103,'汝阳县',now());insert into tbl_province(codeid,parentid,name,createtime) values(410327,4103,'宜阳县',now());insert into tbl_province(codeid%