学步园

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

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,paren