行业分类代码 2017 最新版 创建sql语句

中华人民共和国国家标准标准(GB/T 4754—2017)

插入sql句子(修正后):

insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('A农、林、牧、渔业，null); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 农业，A'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('011',谷物种植，1，01)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'011'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 0112，小麦种植，1，011； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 0113，玉米种植，1，011； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0119，其他谷物种植，1，011)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 豆类、油料和土豆种植，'01'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 0121，豆类种植，1，012； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0122，油料种植，1，012)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 0123，土豆种植，1，012； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'01'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 0131，棉花种植，1，013； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 0132，麻种植，1，013； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0133，糖种植，1，013) insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'013'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'01'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0141，蔬菜种植，1，014) insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0142，食用菌种植，1，014)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0143，花卉种植，1，014) insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0149，其他园艺作物种植，1，'014'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 015，水果种植，1，01； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 0151，仁果类和核果类水果种植，1，015； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0152，葡萄种植，1，015)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'015'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'015'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0159，其他水果种植，1，015)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 016，坚果，含油果，香料和饮料作物种植； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 坚果种植，016； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'016'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0163，香料作物种植，1，016)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0164，茶叶种植，1，016)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0169，其他饮料作物种植，1，016)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'01'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 中草药种植，017； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0179，其他中草药种植，1，017)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 018，草种植及割草，1，01； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 一、'018'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0182，天然草原割草，1，018) insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0190，其他农业，1，01)； insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 林业，A'); insert into Industry (IndustryCode,IndustryName,IndustryState,ParntID) values ('021','林木育种和育苗',1,'02');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0211','林木育种',1,'021');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0212','林木育苗',1,'021');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0220','造林和更新',1,'02');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('023','森林经营、管护和改培',1,'02');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0231','森林经营和管护',1,'023');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0232','森林改培',1,'023');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('024','木材和竹材采运',1,'02');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0241','木材采运',1,'024');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0242','竹材采运',1,'024');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('025','林产品采集',1,'02');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0251','木竹材林产品采集',1,'025');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0252','非木竹材林产品采集',1,'025');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('03','畜牧业',1,'A');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('031','牲畜饲养',1,'03');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0311','牛的饲养',1,'031');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0312','马的饲养',1,'031');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0313','猪的饲养',1,'031');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0314','羊的饲养',1,'031');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0315','骆驼饲养',1,'031');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0319','其他牲畜饲养',1,'031');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('032','家禽饲养',1,'03');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0321','鸡的饲养',1,'032');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0322','鸭的饲养',1,'032');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0323','鹅的饲养',1,'032');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0329','其他家禽饲养',1,'032');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0330','狩猎和捕捉动物',1,'03');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('039','其他畜牧业',1,'03');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0391','兔的饲养',1,'039');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0392','蜜蜂饲养',1,'039');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0399','其他未列明畜牧业',1,'039');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('04','渔业',1,'A');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('041','水产养殖',1,'04');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0411','海水养殖',1,'041');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0412','内陆养殖',1,'041');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('042','水产捕捞',1,'04');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0421','海水捕捞',1,'042');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0422','内陆捕捞',1,'042');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('05','农、林、牧、渔专业及辅助性活动',1,'A');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('051','农业专业及辅助性活动',1,'05');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0511','种子种苗培育活动',1,'051');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0512','农业机械活动',1,'051');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0513','灌溉活动',1,'051');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0514','农产品初加工活动',1,'051');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0515','农作物病虫害防治活动',1,'051');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0519','其他农业专业及辅助性活动',1,'051');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('052','林业专业及辅助性活动',1,'05');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0521','林业有害生物防治活动',1,'052');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0522','森林防火活动',1,'052');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0523','林产品初级加工活动',1,'052');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0529','其他林业专业及辅助性活动',1,'052');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('053','畜牧专业及辅助性活动',1,'05');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0531','畜牧良种繁殖活动',1,'053');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0532','畜禽粪污处理活动',1,'053');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0539','其他畜牧专业及辅助性活动',1,'053');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('054','渔业专业及辅助性活动',1,'05');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0541','鱼苗及鱼种场活动',1,'054');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0549','其他渔业专业及辅助性活动',1,'054');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('B','采矿业',1,null);
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('06','煤炭开采和洗选业',1,'B');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0610','烟煤和无烟煤开采洗选',1,'06');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0620','褐煤开采洗选',1,'06');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0690','其他煤炭采选',1,'06');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('07','石油和天然气开采业',1,'B');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('071','石油开采',1,'07');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0711','陆地石油开采',1,'071');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0712','海洋石油开采',1,'071');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('072','天然气开采',1,'07');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0721','陆地天然气开采',1,'072');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0722','海洋天然气及可燃冰开采',1,'072');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('08','黑色金属矿采选业',1,'B');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0810','铁矿采选',1,'08');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0820','锰矿、铬矿采选',1,'08');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0890','其他黑色金属矿采选',1,'08');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('09','有色金属矿采选业',1,'B');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('091','常用有色金属矿采选',1,'09');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0911','铜矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0912','铅锌矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0913','镍钴矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0914','锡矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0915','锑矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0916','铝矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0917','镁矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0919','其他常用有色金属矿采选',1,'091');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('092','贵金属矿采选',1,'09');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0921','金矿采选',1,'092');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0922','银矿采选',1,'092');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0929','其他贵金属矿采选',1,'092');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('093','稀有稀土金属矿采选',1,'09');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0931','钨钼矿采选',1,'093');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0932','稀土金属矿采选',1,'093');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0933','放射性金属矿采选',1,'093');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0939','其他稀有金属矿采选',1,'093');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('10','非金属矿采选业',1,'B');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('101','土砂石开采',1,'10');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1011','石灰石、石膏开采',1,'101');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1012','建筑装饰用石开采',1,'101');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1013','耐火土石开采',1,'101');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1019','粘土及其他土砂石开采',1,'101');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1020','化学矿开采',1,'10');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1030','采盐',1,'10');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('109','石棉及其他非金属矿采选',1,'10');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1091','石棉、云母矿采选',1,'109');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1092','石墨、滑石采选',1,'109');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1093','宝石、玉石采选',1,'109');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1099','其他未列明非金属矿采选',1,'109');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('11','开采专业及辅助性活动',1,'B');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1110','煤炭开采和洗选专业及辅助性活动',1,'11');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1120','石油和天然气开采专业及辅助性活动',1,'11');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1190','其他开采专业及辅助性活动',1,'11');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('12','其他采矿业',1,'B');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1200','其他采矿业',1,'12');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('C','制造业',1,null);
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('13','农副食品加工业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('131','谷物磨制',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1311','稻谷加工',1,'131');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1312','小麦加工',1,'131');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1313','玉米加工',1,'131');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1314','杂粮加工',1,'131');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1319','其他谷物磨制',1,'131');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('132','饲料加工 ',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1321','宠物饲料加工',1,'132');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1329','其他饲料加工',1,'132');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('133','植物油加工',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1331','食用植物油加工',1,'133');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1332','非食用植物油加工',1,'133');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1340','制糖业',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('135','屠宰及肉类加工',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1351','牲畜屠宰',1,'135');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1352','禽类屠宰',1,'135');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1353','肉制品及副产品加工',1,'135');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('136','水产品加工',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1361','水产品冷冻加工',1,'136');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1362','鱼糜制品及水产品干腌制加工',1,'136');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1363','鱼油提取及制品制造',1,'136');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1369','其他水产品加工',1,'136');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('137','蔬菜、菌类、水果和坚果加工',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1371','蔬菜加工',1,'137');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1372','食用菌加工',1,'137');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1373','水果和坚果加工',1,'137');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('139','其他农副食品加工',1,'13');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1391','淀粉及淀粉制品制造',1,'139');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1392','豆制品制造',1,'139');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1393','蛋品加工',1,'139');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1399','其他未列明农副食品加工',1,'139');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('14','食品制造业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('141','焙烤食品制造',1,'14');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1411','糕点、面包制造',1,'141');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1419','饼干及其他焙烤食品制造',1,'141');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('142','糖果、巧克力及蜜饯制造',1,'14');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1421','糖果、巧克力制造',1,'142');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1422','蜜饯制作',1,'142');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('143','方便食品制造',1,'14');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1431','米、面制品制造',1,'143');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1432','速冻食品制造',1,'143');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1433','方便面制造',1,'143');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1439','其他方便食品制造',1,'143');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('144','乳制品制造',1,'14');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1441','液体乳制造',1,'144');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1442','乳粉制造',1,'144');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1449','其他乳制品制造',1,'144');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('145','罐头食品制造',1,'14');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1451','肉、禽类罐头制造',1,'145');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1452','水产品罐头制造',1,'145');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1453','蔬菜、水果罐头制造',1,'145');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1459','其他罐头食品制造',1,'145');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('146','调味品、发酵制品制造',1,'14');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1461','味精制造',1,'146');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1462','酱油、食醋及类似制品制造',1,'146');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1469','其他调味品、发酵制品制造',1,'146');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('149','其他食品制造',1,'14');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1491','营养食品制造',1,'149');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1492','保健食品制造',1,'149');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1493','冷冻饮品及食用冰制造',1,'149');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1494','盐加工 ',1,'149');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1495','食品及饲料添加剂制造',1,'149');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1499','其他未列明食品制造',1,'149');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('15','酒、饮料及精制茶制造业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('151','酒的制造',1,'15');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1511','酒精制造',1,'151');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1512','白酒制造',1,'151');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1513','啤酒制造',1,'151');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1514','黄酒制造',1,'151');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1515','葡萄酒制造',1,'151');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1519','其他酒制造',1,'151');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('152','饮料制造',1,'15');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1521','碳酸饮料制造',1,'152');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1522','瓶（罐）装饮用水制造',1,'152');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1523','果菜汁及果菜汁饮料制造',1,'152');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1524','含乳饮料和植物蛋白饮料制造',1,'152');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1525','固体饮料制造',1,'152');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1529','茶饮料及其他饮料制造',1,'152');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1530','精制茶加工',1,'15');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('16','烟草制品业 ',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1610','烟叶复烤',1,'16');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1620','卷烟制造',1,'16');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1690','其他烟草制品制造',1,'16');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('17','纺织业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('171','棉纺织及印染精加工',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1711','棉纺纱加工',1,'171');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1712','棉织造加工',1,'171');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1713','棉印染精加工',1,'171');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('172','毛纺织及染整精加工',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1721','毛条和毛纱线加工',1,'172');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1722','毛织造加工',1,'172');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1723','毛染整精加工',1,'172');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('173','麻纺织及染整精加工',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1731','麻纤维纺前加工和纺纱',1,'173');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1732','麻织造加工',1,'173');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1733','麻染整精加工',1,'173');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('174','丝绢纺织及印染精加工',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1741','缫丝加工',1,'174');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1742','绢纺和丝织加工',1,'174');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1743','丝印染精加工',1,'174');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('175','化纤织造及印染精加工',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1751','化纤织造加工',1,'175');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1752','化纤织物染整精加工',1,'175');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('176','针织或钩针编织物及其制品制造',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1761','针织或钩针编织物织造',1,'176');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1762','针织或钩针编织物印染精加工',1,'176');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1763','针织或钩针编织品制造',1,'176');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('177','家用纺织制成品制造',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1771','床上用品制造',1,'177');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1772','毛巾类制品制造',1,'177');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1773','窗帘、布艺类产品制造',1,'177');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1779','其他家用纺织制成品制造',1,'177');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('178','产业用纺织制成品制造',1,'17');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1781','非织造布制造',1,'178');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1782','绳、索、缆制造',1,'178');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1783','纺织带和帘子布制造',1,'178');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1784','篷、帆布制造',1,'178');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1789','其他产业用纺织制成品制造',1,'178');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('18','纺织服装、服饰业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('181','机织服装制造',1,'18');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1811','运动机织服装制造',1,'181');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1819','其他机织服装制造',1,'181');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('182','针织或钩针编织服装制造',1,'18');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1821','运动休闲针织服装制造',1,'182');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1829','其他针织或钩针编织服装制造',1,'182');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1830','服饰制造',1,'18');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('19','皮革、毛皮、羽毛及其制品和制鞋业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1910','皮革鞣制加工',1,'19');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('192','皮革制品制造',1,'19');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1921','皮革服装制造',1,'192');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1922','皮箱、包(袋)制造',1,'192');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1923','皮手套及皮装饰制品制造 ',1,'192');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1929','其他皮革制品制造',1,'192');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('193','毛皮鞣制及制品加工',1,'19');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1931','毛皮鞣制加工',1,'193');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1932','毛皮服装加工',1,'193');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1939','其他毛皮制品加工',1,'193');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('194','羽毛(绒)加工及制品制造',1,'19');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1941','羽毛(绒)加工',1,'194');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1942','羽毛(绒)制品加工',1,'194');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('195','制鞋业',1,'19');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1951','纺织面料鞋制造',1,'195');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1952','皮鞋制造',1,'195');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1953','塑料鞋制造',1,'195');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1954','橡胶鞋制造',1,'195');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('1959','其他制鞋业',1,'195');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('20','木材加工和木、竹、藤、棕、草制品业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('201','木材加工',1,'20');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2011','锯材加工',1,'201');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2012','木片加工',1,'201');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2013','单板加工',1,'201');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2019','其他木材加工',1,'201');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('202','人造板制造',1,'20');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2021','胶合板制造',1,'202');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2022','纤维板制造',1,'202');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2023','刨花板制造',1,'202');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2029','其他人造板制造',1,'202');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('203','木制品制造',1,'20');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2031','建筑用木料及木材组件加工',1,'203');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2032','木门窗制造',1,'203');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2033','木楼梯制造',1,'203');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2034','木地板制造',1,'203');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2035','木制容器制造',1,'203');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2039','软木制品及其他木制品制造',1,'203');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('204','竹、藤、棕、草制品制造',1,'20');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2041','竹制品制造',1,'204');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2042','藤制品制造',1,'204');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2043','棕制品制造',1,'204');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2049','草及其他制品制造',1,'204');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('21','家具制造业 ',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2110','木质家具制造',1,'21');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2120','竹、藤家具制造',1,'21');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2130','金属家具制造',1,'21');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2140','塑料家具制造',1,'21');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2190','其他家具制造',1,'21');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('22','造纸和纸制品业 ',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('221','纸浆制造',1,'22');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2211','木竹浆制造',1,'221');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2212','非木竹浆制造',1,'221');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('222','造纸',1,'22');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2221','机制纸及纸板制造',1,'222');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2222','手工纸制造',1,'222');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2223','加工纸制造',1,'222');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('223','纸制品制造',1,'22');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2231','纸和纸板容器制造',1,'223');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2239','其他纸制品制造',1,'223');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('23','印刷和记录媒介复制业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('231','印刷',1,'23');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2311','书、报刊印刷',1,'231');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2312','本册印制',1,'231');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2319','包装装潢及其他印刷',1,'231');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2320','装订及印刷相关服务',1,'23');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2330','记录媒介复制',1,'23');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('24','文教、工美、体育和娱乐用品制造业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('241','文教办公用品制造',1,'24');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2411','文具制造',1,'241');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2412','笔的制造',1,'241');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2413','教学用模型及教具制造',1,'241');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2414','墨水、墨汁制造',1,'241');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2419','其他文教办公用品制造',1,'241');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('242','乐器制造',1,'24');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2421','中乐器制造',1,'242');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2422','西乐器制造',1,'242');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2423','电子乐器制造',1,'242');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2429','其他乐器及零件制造',1,'242');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('243','工艺美术及礼仪用品制造',1,'24');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2431','雕塑工艺品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2432','金属工艺品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2433','漆器工艺品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2434','花画工艺品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2435','天然植物纤维编织工艺品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2436','抽纱刺绣工艺品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2437','地毯、挂毯制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2438','珠宝首饰及有关物品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2439','其他工艺美术及礼仪用品制造',1,'243');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('244','体育用品制造',1,'24');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2441','球类制造',1,'244');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2442','专项运动器材及配件制造',1,'244');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2443','健身器材制造',1,'244');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2444','运动防护用具制造',1,'244');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2449','其他体育用品制造',1,'244');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('245','玩具制造',1,'24');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2451','电玩具制造',1,'245');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2452','塑胶玩具制造',1,'245');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2453','金属玩具制造',1,'245');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2454','弹射玩具制造',1,'245');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2455','娃娃玩具制造',1,'245');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2456','儿童乘骑玩耍的童车类产品制造',1,'245');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2459','其他玩具制造',1,'245');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('246','游艺器材及娱乐用品制造',1,'24');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2461','露天游乐场所游乐设备制造',1,'246');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2462','游艺用品及室内游艺器材制造',1,'246');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2469','其他娱乐用品制造',1,'246');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('25','石油、煤炭及其他燃料加工业 ',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('251','精炼石油产品制造',1,'25');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2511','原油加工及石油制品制造',1,'251');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2519','其他原油制造',1,'251');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('252','煤炭加工',1,'25');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2521','炼焦',1,'252');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2522','煤制合成气生产',1,'252');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2523','煤制液体燃料生产',1,'252');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2524','煤制品制造',1,'252');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2529','其他煤炭加工',1,'252');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2530','核燃料加工',1,'25');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('254','生物质燃料加工',1,'25');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2541','生物质液体燃料生产',1,'254');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2542','生物质致密成型燃料加工',1,'254');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('26','化学原料和化学制品制造业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('261','基础化学原料制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2611','无机酸制造',1,'261');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2612','无机碱制造',1,'261');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2613','无机盐制造',1,'261');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2614','有机化学原料制造',1,'261');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2619','其他基础化学原料制造',1,'261');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('262','肥料制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2621','氮肥制造',1,'262');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2622','磷肥制造',1,'262');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2623','钾肥制造',1,'262');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2624','复混肥料制造',1,'262');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2625','有机肥料及微生物肥料制造',1,'262');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2629','其他肥料制造',1,'262');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('263','农药制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2631','化学农药制造',1,'263');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2632','生物化学农药及微生物农药制造',1,'263');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('264','涂料、油墨、颜料及类似产品制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2641','涂料制造',1,'264');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2642','油墨及类似产品制造',1,'264');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2643','工业颜料制造',1,'264');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2644','工艺美术颜料制造',1,'264');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2645','染料制造',1,'264');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2646','密封用填料及类似品制造',1,'264');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('265','合成材料制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2651','初级形态塑料及合成树脂制造',1,'265');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2652','合成橡胶制造',1,'265');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2653','合成纤维单(聚合)体制造',1,'265');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2659','其他合成材料制造',1,'265');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('266','专用化学产品制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2661','化学试剂和助剂制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2662','专项化学用品制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2663','林产化学产品制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2664','文化用信息化学品制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2665','医学生产用信息化学品制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2666','环境污染处理专用药剂材料制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2667','动物胶制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2669','其他专用化学产品制造',1,'266');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('267','炸药、火工及焰火产品制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2671','炸药及火工产品制造',1,'267');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2672','焰火、鞭炮产品制造 ',1,'267');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('268','日用化学产品制造',1,'26');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2681','肥皂及洗涤剂制造',1,'268');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2682','化妆品制造',1,'268');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2683','口腔清洁用品制造',1,'268');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2684','香料、香精制造',1,'268');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2689','其他日用化学产品制造',1,'268');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('27','医药制造业 ',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2710','化学药品原料药制造',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2720','化学药品制剂制造',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2730','中药饮片加工',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2740','中成药生产',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2750','兽用药品制造',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('276','生物药品制品制造',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2761','生物药品制造',1,'276');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2762','基因工程药物和疫苗制造',1,'276');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2770','卫生材料及医药用品制造',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2780','药用辅料及包装材料',1,'27');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('28','化学纤维制造业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('281','纤维素纤维原料及纤维制造',1,'28');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2811','化纤浆粕制造',1,'281');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2812','人造纤维（纤维素纤维）制造',1,'281');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('282','合成纤维制造',1,'28');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2821','锦纶纤维制造',1,'282');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2822','涤纶纤维制造',1,'282');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2823','腈纶纤维制造',1,'282');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2824','维纶纤维制造',1,'282');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2825','丙纶纤维制造',1,'282');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2826','氨纶纤维制造',1,'282');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2829','其他合成纤维制造',1,'282');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('283','生物基材料制造',1,'28');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2831','生物基化学纤维制造',1,'283');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2832','生物基、淀粉基新材料制造',1,'283');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('29','橡胶和塑料制品业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('291','橡胶制品业',1,'29');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2911','轮胎制造',1,'291');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2912','橡胶板、管、带制造',1,'291');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2913','橡胶零件制造',1,'291');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2914','再生橡胶制造',1,'291');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2915','日用及医用橡胶制品制造',1,'291');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2916','运动场地用塑胶制造',1,'291');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2919','其他橡胶制品制造',1,'291');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('292','塑料制品业',1,'29');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2921','塑料薄膜制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2922','塑料板、管、型材制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2923','塑料丝、绳及编织品制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2924','泡沫塑料制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2925','塑料人造革、合成革制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2926','塑料包装箱及容器制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2927','日用塑料制品制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2928','人造草坪制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('2929','塑料零件及其他塑料制品制造',1,'292');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('30','非金属矿物制品业',1,'C');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('301','水泥、石灰和石膏制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3011','水泥制造',1,'301');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3012','石灰和石膏制造',1,'301');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('302','石膏、水泥制品及类似制品制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3021','水泥制品制造',1,'302');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3022','砼结构构件制造',1,'302');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3023','石棉水泥制品制造',1,'302');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3024','轻质建筑材料制造',1,'302');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3029','其他水泥类似制品制造',1,'302');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('303','砖瓦、石材等建筑材料制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3031','粘土砖瓦及建筑砌块制造',1,'303');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3032','建筑用石加工',1,'303');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3033','防水建筑材料制造',1,'303');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3034','隔热和隔音材料制造',1,'303');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3039','其他建筑材料制造',1,'303');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('304','玻璃制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3041','平板玻璃制造',1,'304');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3042','特种玻璃制造',1,'304');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3049','其他玻璃制造',1,'304');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('305','玻璃制品制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3051','技术玻璃制品制造',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3052','光学玻璃制造',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3053','玻璃仪器制造',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3054','日用玻璃制品制造',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3055','玻璃包装容器制造',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3056','玻璃保温容器制造',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3057','制镜及类似品加工',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3059','其他玻璃制品制造',1,'305');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('306','玻璃纤维和玻璃纤维增强塑料制品制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3061','玻璃纤维及制品制造',1,'306');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3062','玻璃纤维增强塑料制品制造',1,'306');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('307','陶瓷制品制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3071','建筑陶瓷制品制造',1,'307');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3072','卫生陶瓷制品制造',1,'307');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3073','特种陶瓷制品制造',1,'307');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3074','日用陶瓷制品制造',1,'307');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3075','陈设艺术陶瓷制造',1,'307');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3076','园艺陶瓷制造',1,'307');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3079','其他陶瓷制品制造',1,'307');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('308','耐火材料制品制造',1,'30');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3081','石棉制品制造',1,'308');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3082','云母制品制造',1,'308');
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('3089','耐火陶瓷制品及其他耐火材料制造',1,'308');
insert into Industry (IndustryCode,IndustryNam