行业分类代码一览表2022-MySQL版

 

CREATE TABLE t_industry (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
code varchar(20) NOT NULL COMMENT '行业编号',
name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '行业名称',
state int(11) NULL COMMENT '行业状态',
parent_code varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '上级行业编号',
level int(11) NULL COMMENT '行业层级',
PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT

insert into t_industry (code,name,state,parent_code) values ('A','农、林、牧、渔业',1,null);
insert into t_industry (code,name,state,parent_code) values ('01','农业',1,'A');
insert into t_industry (code,name,state,parent_code) values ('011','谷物种植',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0111','稻谷种植',1,'011');
insert into t_industry (code,name,state,parent_code) values ('0112','小麦种植',1,'011');
insert into t_industry (code,name,state,parent_code) values ('0113','玉米种植',1,'011');
insert into t_industry (code,name,state,parent_code) values ('0119','其他谷物种植',1,'011');
insert into t_industry (code,name,state,parent_code) values ('012','豆类、油料和薯类种植',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0121','豆类种植',1,'012');
insert into t_industry (code,name,state,parent_code) values ('0122','油料种植',1,'012');
insert into t_industry (code,name,state,parent_code) values ('0123','薯类种植',1,'012');
insert into t_industry (code,name,state,parent_code) values ('013','棉、麻、糖、烟草种植',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0131','棉花种植',1,'013');
insert into t_industry (code,name,state,parent_code) values ('0132','麻类种植',1,'013');
insert into t_industry (code,name,state,parent_code) values ('0133','糖料种植',1,'013');
insert into t_industry (code,name,state,parent_code) values ('0134','烟草种植',1,'013');
insert into t_industry (code,name,state,parent_code) values ('014','蔬菜、食用菌及园艺作物种植',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0141','蔬菜种植',1,'014');
insert into t_industry (code,name,state,parent_code) values ('0142','食用菌种植',1,'014');
insert into t_industry (code,name,state,parent_code) values ('0143','花卉种植',1,'014');
insert into t_industry (code,name,state,parent_code) values ('0149','其他园艺作物种植',1,'014');
insert into t_industry (code,name,state,parent_code) values ('015','水果种植',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0151','仁果类和核果类水果种植',1,'015');
insert into t_industry (code,name,state,parent_code) values ('0152','葡萄种植',1,'015');
insert into t_industry (code,name,state,parent_code) values ('0153','柑橘类种植',1,'015');
insert into t_industry (code,name,state,parent_code) values ('0154','香蕉等亚热带水果种植',1,'015');
insert into t_industry (code,name,state,parent_code) values ('0159','其他水果种植',1,'015');
insert into t_industry (code,name,state,parent_code) values ('016','坚果、含油果、香料和饮料作物种植',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0161','坚果种植',1,'016');
insert into t_industry (code,name,state,parent_code) values ('0162','含油果种植',1,'016');
insert into t_industry (code,name,state,parent_code) values ('0163','香料作物种植',1,'016');
insert into t_industry (code,name,state,parent_code) values ('0164','茶叶种植',1,'016');
insert into t_industry (code,name,state,parent_code) values ('0169','其他饮料作物种植',1,'016');
insert into t_industry (code,name,state,parent_code) values ('017','中药材种植',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0171','中草药种植',1,'017');
insert into t_industry (code,name,state,parent_code) values ('0179','其他中药材种植',1,'017');
insert into t_industry (code,name,state,parent_code) values ('018','草种植及割草',1,'01');
insert into t_industry (code,name,state,parent_code) values ('0181','草种植',1,'018');
insert into t_industry (code,name,state,parent_code) values ('0182','天然草原割草',1,'018');
insert into t_industry (code,name,state,parent_code) values ('0190','其他农业',1,'01');
insert into t_industry (code,name,state,parent_code) values ('02','林业',1,'A');
insert into t_industry (code,name,state,parent_code) values ('021','林木育种和育苗',1,'02');
insert into t_industry (code,name,state,parent_code) values ('0211','林木育种',1,'021');
insert into t_industry (code,name,state,parent_code) values ('0212','林木育苗',1,'021');
insert into t_industry (code,name,state,parent_code) values ('0220','造林和更新',1,'02');
insert into t_industry (code,name,state,parent_code) values ('023','森林经营、管护和改培',1,'02');
insert into t_industry (code,name,state,parent_code) values ('0231','森林经营和管护',1,'023');
insert into t_industry (code,name,state,parent_code) values ('0232','森林改培',1,'023');
insert into t_industry (code,name,state,parent_code) values ('024','木材和竹材采运',1,'02');
insert into t_industry (code,name,state,parent_code) values ('0241','木材采运',1,'024');
insert into t_industry (code,name,state,parent_code) values ('0242','竹材采运',1,'024');
insert into t_industry (code,name,state,parent_code) values ('025','林产品采集',1,'02');
insert into t_industry (code,name,state,parent_code) values ('0251','木竹材林产品采集',1,'025');
insert into t_industry (code,name,state,parent_code) values ('0252','非木竹材林产品采集',1,'025');
insert into t_industry (code,name,state,parent_code) values ('03','畜牧业',1,'A');
insert into t_industry (code,name,state,parent_code) values ('031','牲畜饲养',1,'03');
insert into t_industry (code,name,state,parent_code) values ('0311','牛的饲养',1,'031');
insert into t_industry (code,name,state,parent_code) values ('0312','马的饲养',1,'031');
insert into t_industry (code,name,state,parent_code) values ('0313','猪的饲养',1,'031');
insert into t_industry (code,name,state,parent_code) values ('0314','羊的饲养',1,'031');
insert into t_industry (code,name,state,parent_code) values ('0315','骆驼饲养',1,'031');
insert into t_industry (code,name,state,parent_code) values ('0319','其他牲畜饲养',1,'031');
insert into t_industry (code,name,state,parent_code) values ('032','家禽饲养',1,'03');
insert into t_industry (code,name,state,parent_code) values ('0321','鸡的饲养',1,'032');
insert into t_industry (code,name,state,parent_code) values ('0322','鸭的饲养',1,'032');
insert into t_industry (code,name,state,parent_code) values ('0323','鹅的饲养',1,'032');
insert into t_industry (code,name,state,parent_code) values ('0329','其他家禽饲养',1,'032');
insert into t_industry (code,name,state,parent_code) values ('0330','狩猎和捕捉动物',1,'03');
insert into t_industry (code,name,state,parent_code) values ('039','其他畜牧业',1,'03');
insert into t_industry (code,name,state,parent_code) values ('0391','兔的饲养',1,'039');
insert into t_industry (code,name,state,parent_code) values ('0392','蜜蜂饲养',1,'039');
insert into t_industry (code,name,state,parent_code) values ('0399','其他未列明畜牧业',1,'039');
insert into t_industry (code,name,state,parent_code) values ('04','渔业',1,'A');
insert into t_industry (code,name,state,parent_code) values ('041','水产养殖',1,'04');
insert into t_industry (code,name,state,parent_code) values ('0411','海水养殖',1,'041');
insert into t_industry (code,name,state,parent_code) values ('0412','内陆养殖',1,'041');
insert into t_industry (code,name,state,parent_code) values ('042','水产捕捞',1,'04');
insert into t_industry (code,name,state,parent_code) values ('0421','海水捕捞',1,'042');
insert into t_industry (code,name,state,parent_code) values ('0422','内陆捕捞',1,'042');
insert into t_industry (code,name,state,parent_code) values ('05','农、林、牧、渔专业及辅助性活动',1,'A');
insert into t_industry (code,name,state,parent_code) values ('051','农业专业及辅助性活动',1,'05');
insert into t_industry (code,name,state,parent_code) values ('0511','种子种苗培育活动',1,'051');
insert into t_industry (code,name,state,parent_code) values ('0512','农业机械活动',1,'051');
insert into t_industry (code,name,state,parent_code) values ('0513','灌溉活动',1,'051');
insert into t_industry (code,name,state,parent_code) values ('0514','农产品初加工活动',1,'051');
insert into t_industry (code,name,state,parent_code) values ('0515','农作物病虫害防治活动',1,'051');
insert into t_industry (code,name,state,parent_code) values ('0519','其他农业专业及辅助性活动',1,'051');
insert into t_industry (code,name,state,parent_code) values ('052','林业专业及辅助性活动',1,'05');
insert into t_industry (code,name,state,parent_code) values ('0521','林业有害生物防治活动',1,'052');
insert into t_industry (code,name,state,parent_code) values ('0522','森林防火活动',1,'052');
insert into t_industry (code,name,state,parent_code) values ('0523','林产品初级加工活动',1,'052');
insert into t_industry (code,name,state,parent_code) values ('0529','其他林业专业及辅助性活动',1,'052');
insert into t_industry (code,name,state,parent_code) values ('053','畜牧专业及辅助性活动',1,'05');
insert into t_industry (code,name,state,parent_code) values ('0531','畜牧良种繁殖活动',1,'053');
insert into t_industry (code,name,state,parent_code) values ('0532','畜禽粪污处理活动',1,'053');
insert into t_industry (code,name,state,parent_code) values ('0539','其他畜牧专业及辅助性活动',1,'053');
insert into t_industry (code,name,state,parent_code) values ('054','渔业专业及辅助性活动',1,'05');
insert into t_industry (code,name,state,parent_code) values ('0541','鱼苗及鱼种场活动',1,'054');
insert into t_industry (code,name,state,parent_code) values ('0549','其他渔业专业及辅助性活动',1,'054');
insert into t_industry (code,name,state,parent_code) values ('B','采矿业',1,null);
insert into t_industry (code,name,state,parent_code) values ('06','煤炭开采和洗选业',1,'B');
insert into t_industry (code,name,state,parent_code) values ('0610','烟煤和无烟煤开采洗选',1,'06');
insert into t_industry (code,name,state,parent_code) values ('0620','褐煤开采洗选',1,'06');
insert into t_industry (code,name,state,parent_code) values ('0690','其他煤炭采选',1,'06');
insert into t_industry (code,name,state,parent_code) values ('07','石油和天然气开采业',1,'B');
insert into t_industry (code,name,state,parent_code) values ('071','石油开采',1,'07');
insert into t_industry (code,name,state,parent_code) values ('0711','陆地石油开采',1,'071');
insert into t_industry (code,name,state,parent_code) values ('0712','海洋石油开采',1,'071');
insert into t_industry (code,name,state,parent_code) values ('072','天然气开采',1,'07');
insert into t_industry (code,name,state,parent_code) values ('0721','陆地天然气开采',1,'072');
insert into t_industry (code,name,state,parent_code) values ('0722','海洋天然气及可燃冰开采',1,'072');
insert into t_industry (code,name,state,parent_code) values ('08','黑色金属矿采选业',1,'B');
insert into t_industry (code,name,state,parent_code) values ('0810','铁矿采选',1,'08');
insert into t_industry (code,name,state,parent_code) values ('0820','锰矿、铬矿采选',1,'08');
insert into t_industry (code,name,state,parent_code) values ('0890','其他黑色金属矿采选',1,'08');
insert into t_industry (code,name,state,parent_code) values ('09','有色金属矿采选业',1,'B');
insert into t_industry (code,name,state,parent_code) values ('091','常用有色金属矿采选',1,'09');
insert into t_industry (code,name,state,parent_code) values ('0911','铜矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('0912','铅锌矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('0913','镍钴矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('0914','锡矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('0915','锑矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('0916','铝矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('0917','镁矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('0919','其他常用有色金属矿采选',1,'091');
insert into t_industry (code,name,state,parent_code) values ('092','贵金属矿采选',1,'09');
insert into t_industry (code,name,state,parent_code) values ('0921','金矿采选',1,'092');
insert into t_industry (code,name,state,parent_code) values ('0922','银矿采选',1,'092');
insert into t_industry (code,name,state,parent_code) values ('0929','其他贵金属矿采选',1,'092');
insert into t_industry (code,name,state,parent_code) values ('093','稀有稀土金属矿采选',1,'09');
insert into t_industry (code,name,state,parent_code) values ('0931','钨钼矿采选',1,'093');
insert into t_industry (code,name,state,parent_code) values ('0932','稀土金属矿采选',1,'093');
insert into t_industry (code,name,state,parent_code) values ('0933','放射性金属矿采选',1,'093');
insert into t_industry (code,name,state,parent_code) values ('0939','其他稀有金属矿采选',1,'093');
insert into t_industry (code,name,state,parent_code) values ('10','非金属矿采选业',1,'B');
insert into t_industry (code,name,state,parent_code) values ('101','土砂石开采',1,'10');
insert into t_industry (code,name,state,parent_code) values ('1011','石灰石、石膏开采',1,'101');
insert into t_industry (code,name,state,parent_code) values ('1012','建筑装饰用石开采',1,'101');
insert into t_industry (code,name,state,parent_code) values ('1013','耐火土石开采',1,'101');
insert into t_industry (code,name,state,parent_code) values ('1019','粘土及其他土砂石开采',1,'101');
insert into t_industry (code,name,state,parent_code) values ('1020','化学矿开采',1,'10');
insert into t_industry (code,name,state,parent_code) values ('1030','采盐',1,'10');
insert into t_industry (code,name,state,parent_code) values ('109','石棉及其他非金属矿采选',1,'10');
insert into t_industry (code,name,state,parent_code) values ('1091','石棉、云母矿采选',1,'109');
insert into t_industry (code,name,state,parent_code) values ('1092','石墨、滑石采选',1,'109');
insert into t_industry (code,name,state,parent_code) values ('1093','宝石、玉石采选',1,'109');
insert into t_industry (code,name,state,parent_code) values ('1099','其他未列明非金属矿采选',1,'109');
insert into t_industry (code,name,state,parent_code) values ('11','开采专业及辅助性活动',1,'B');
insert into t_industry (code,name,state,parent_code) values ('1110','煤炭开采和洗选专业及辅助性活动',1,'11');
insert into t_industry (code,name,state,parent_code) values ('1120','石油和天然气开采专业及辅助性活动',1,'11');
insert into t_industry (code,name,state,parent_code) values ('1190','其他开采专业及辅助性活动',1,'11');
insert into t_industry (code,name,state,parent_code) values ('12','其他采矿业',1,'B');
insert into t_industry (code,name,state,parent_code) values ('1200','其他采矿业',1,'12');
insert into t_industry (code,name,state,parent_code) values ('C','制造业',1,null);
insert into t_industry (code,name,state,parent_code) values ('13','农副食品加工业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('131','谷物磨制',1,'13');
insert into t_industry (code,name,state,parent_code) values ('1311','稻谷加工',1,'131');
insert into t_industry (code,name,state,parent_code) values ('1312','小麦加工',1,'131');
insert into t_industry (code,name,state,parent_code) values ('1313','玉米加工',1,'131');
insert into t_industry (code,name,state,parent_code) values ('1314','杂粮加工',1,'131');
insert into t_industry (code,name,state,parent_code) values ('1319','其他谷物磨制',1,'131');
insert into t_industry (code,name,state,parent_code) values ('132','饲料加工 ',1,'13');
insert into t_industry (code,name,state,parent_code) values ('1321','宠物饲料加工',1,'132');
insert into t_industry (code,name,state,parent_code) values ('1329','其他饲料加工',1,'132');
insert into t_industry (code,name,state,parent_code) values ('133','植物油加工',1,'13');
insert into t_industry (code,name,state,parent_code) values ('1331','食用植物油加工',1,'133');
insert into t_industry (code,name,state,parent_code) values ('1332','非食用植物油加工',1,'133');
insert into t_industry (code,name,state,parent_code) values ('1340','制糖业',1,'13');
insert into t_industry (code,name,state,parent_code) values ('135','屠宰及肉类加工',1,'13');
insert into t_industry (code,name,state,parent_code) values ('1351','牲畜屠宰',1,'135');
insert into t_industry (code,name,state,parent_code) values ('1352','禽类屠宰',1,'135');
insert into t_industry (code,name,state,parent_code) values ('1353','肉制品及副产品加工',1,'135');
insert into t_industry (code,name,state,parent_code) values ('136','水产品加工',1,'13');
insert into t_industry (code,name,state,parent_code) values ('1361','水产品冷冻加工',1,'136');
insert into t_industry (code,name,state,parent_code) values ('1362','鱼糜制品及水产品干腌制加工',1,'136');
insert into t_industry (code,name,state,parent_code) values ('1363','鱼油提取及制品制造',1,'136');
insert into t_industry (code,name,state,parent_code) values ('1369','其他水产品加工',1,'136');
insert into t_industry (code,name,state,parent_code) values ('137','蔬菜、菌类、水果和坚果加工',1,'13');
insert into t_industry (code,name,state,parent_code) values ('1371','蔬菜加工',1,'137');
insert into t_industry (code,name,state,parent_code) values ('1372','食用菌加工',1,'137');
insert into t_industry (code,name,state,parent_code) values ('1373','水果和坚果加工',1,'137');
insert into t_industry (code,name,state,parent_code) values ('139','其他农副食品加工',1,'13');
insert into t_industry (code,name,state,parent_code) values ('1391','淀粉及淀粉制品制造',1,'139');
insert into t_industry (code,name,state,parent_code) values ('1392','豆制品制造',1,'139');
insert into t_industry (code,name,state,parent_code) values ('1393','蛋品加工',1,'139');
insert into t_industry (code,name,state,parent_code) values ('1399','其他未列明农副食品加工',1,'139');
insert into t_industry (code,name,state,parent_code) values ('14','食品制造业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('141','焙烤食品制造',1,'14');
insert into t_industry (code,name,state,parent_code) values ('1411','糕点、面包制造',1,'141');
insert into t_industry (code,name,state,parent_code) values ('1419','饼干及其他焙烤食品制造',1,'141');
insert into t_industry (code,name,state,parent_code) values ('142','糖果、巧克力及蜜饯制造',1,'14');
insert into t_industry (code,name,state,parent_code) values ('1421','糖果、巧克力制造',1,'142');
insert into t_industry (code,name,state,parent_code) values ('1422','蜜饯制作',1,'142');
insert into t_industry (code,name,state,parent_code) values ('143','方便食品制造',1,'14');
insert into t_industry (code,name,state,parent_code) values ('1431','米、面制品制造',1,'143');
insert into t_industry (code,name,state,parent_code) values ('1432','速冻食品制造',1,'143');
insert into t_industry (code,name,state,parent_code) values ('1433','方便面制造',1,'143');
insert into t_industry (code,name,state,parent_code) values ('1439','其他方便食品制造',1,'143');
insert into t_industry (code,name,state,parent_code) values ('144','乳制品制造',1,'14');
insert into t_industry (code,name,state,parent_code) values ('1441','液体乳制造',1,'144');
insert into t_industry (code,name,state,parent_code) values ('1442','乳粉制造',1,'144');
insert into t_industry (code,name,state,parent_code) values ('1449','其他乳制品制造',1,'144');
insert into t_industry (code,name,state,parent_code) values ('145','罐头食品制造',1,'14');
insert into t_industry (code,name,state,parent_code) values ('1451','肉、禽类罐头制造',1,'145');
insert into t_industry (code,name,state,parent_code) values ('1452','水产品罐头制造',1,'145');
insert into t_industry (code,name,state,parent_code) values ('1453','蔬菜、水果罐头制造',1,'145');
insert into t_industry (code,name,state,parent_code) values ('1459','其他罐头食品制造',1,'145');
insert into t_industry (code,name,state,parent_code) values ('146','调味品、发酵制品制造',1,'14');
insert into t_industry (code,name,state,parent_code) values ('1461','味精制造',1,'146');
insert into t_industry (code,name,state,parent_code) values ('1462','酱油、食醋及类似制品制造',1,'146');
insert into t_industry (code,name,state,parent_code) values ('1469','其他调味品、发酵制品制造',1,'146');
insert into t_industry (code,name,state,parent_code) values ('149','其他食品制造',1,'14');
insert into t_industry (code,name,state,parent_code) values ('1491','营养食品制造',1,'149');
insert into t_industry (code,name,state,parent_code) values ('1492','保健食品制造',1,'149');
insert into t_industry (code,name,state,parent_code) values ('1493','冷冻饮品及食用冰制造',1,'149');
insert into t_industry (code,name,state,parent_code) values ('1494','盐加工 ',1,'149');
insert into t_industry (code,name,state,parent_code) values ('1495','食品及饲料添加剂制造',1,'149');
insert into t_industry (code,name,state,parent_code) values ('1499','其他未列明食品制造',1,'149');
insert into t_industry (code,name,state,parent_code) values ('15','酒、饮料及精制茶制造业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('151','酒的制造',1,'15');
insert into t_industry (code,name,state,parent_code) values ('1511','酒精制造',1,'151');
insert into t_industry (code,name,state,parent_code) values ('1512','白酒制造',1,'151');
insert into t_industry (code,name,state,parent_code) values ('1513','啤酒制造',1,'151');
insert into t_industry (code,name,state,parent_code) values ('1514','黄酒制造',1,'151');
insert into t_industry (code,name,state,parent_code) values ('1515','葡萄酒制造',1,'151');
insert into t_industry (code,name,state,parent_code) values ('1519','其他酒制造',1,'151');
insert into t_industry (code,name,state,parent_code) values ('152','饮料制造',1,'15');
insert into t_industry (code,name,state,parent_code) values ('1521','碳酸饮料制造',1,'152');
insert into t_industry (code,name,state,parent_code) values ('1522','瓶（罐）装饮用水制造',1,'152');
insert into t_industry (code,name,state,parent_code) values ('1523','果菜汁及果菜汁饮料制造',1,'152');
insert into t_industry (code,name,state,parent_code) values ('1524','含乳饮料和植物蛋白饮料制造',1,'152');
insert into t_industry (code,name,state,parent_code) values ('1525','固体饮料制造',1,'152');
insert into t_industry (code,name,state,parent_code) values ('1529','茶饮料及其他饮料制造',1,'152');
insert into t_industry (code,name,state,parent_code) values ('1530','精制茶加工',1,'15');
insert into t_industry (code,name,state,parent_code) values ('16','烟草制品业 ',1,'C');
insert into t_industry (code,name,state,parent_code) values ('1610','烟叶复烤',1,'16');
insert into t_industry (code,name,state,parent_code) values ('1620','卷烟制造',1,'16');
insert into t_industry (code,name,state,parent_code) values ('1690','其他烟草制品制造',1,'16');
insert into t_industry (code,name,state,parent_code) values ('17','纺织业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('171','棉纺织及印染精加工',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1711','棉纺纱加工',1,'171');
insert into t_industry (code,name,state,parent_code) values ('1712','棉织造加工',1,'171');
insert into t_industry (code,name,state,parent_code) values ('1713','棉印染精加工',1,'171');
insert into t_industry (code,name,state,parent_code) values ('172','毛纺织及染整精加工',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1721','毛条和毛纱线加工',1,'172');
insert into t_industry (code,name,state,parent_code) values ('1722','毛织造加工',1,'172');
insert into t_industry (code,name,state,parent_code) values ('1723','毛染整精加工',1,'172');
insert into t_industry (code,name,state,parent_code) values ('173','麻纺织及染整精加工',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1731','麻纤维纺前加工和纺纱',1,'173');
insert into t_industry (code,name,state,parent_code) values ('1732','麻织造加工',1,'173');
insert into t_industry (code,name,state,parent_code) values ('1733','麻染整精加工',1,'173');
insert into t_industry (code,name,state,parent_code) values ('174','丝绢纺织及印染精加工',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1741','缫丝加工',1,'174');
insert into t_industry (code,name,state,parent_code) values ('1742','绢纺和丝织加工',1,'174');
insert into t_industry (code,name,state,parent_code) values ('1743','丝印染精加工',1,'174');
insert into t_industry (code,name,state,parent_code) values ('175','化纤织造及印染精加工',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1751','化纤织造加工',1,'175');
insert into t_industry (code,name,state,parent_code) values ('1752','化纤织物染整精加工',1,'175');
insert into t_industry (code,name,state,parent_code) values ('176','针织或钩针编织物及其制品制造',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1761','针织或钩针编织物织造',1,'176');
insert into t_industry (code,name,state,parent_code) values ('1762','针织或钩针编织物印染精加工',1,'176');
insert into t_industry (code,name,state,parent_code) values ('1763','针织或钩针编织品制造',1,'176');
insert into t_industry (code,name,state,parent_code) values ('177','家用纺织制成品制造',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1771','床上用品制造',1,'177');
insert into t_industry (code,name,state,parent_code) values ('1772','毛巾类制品制造',1,'177');
insert into t_industry (code,name,state,parent_code) values ('1773','窗帘、布艺类产品制造',1,'177');
insert into t_industry (code,name,state,parent_code) values ('1779','其他家用纺织制成品制造',1,'177');
insert into t_industry (code,name,state,parent_code) values ('178','产业用纺织制成品制造',1,'17');
insert into t_industry (code,name,state,parent_code) values ('1781','非织造布制造',1,'178');
insert into t_industry (code,name,state,parent_code) values ('1782','绳、索、缆制造',1,'178');
insert into t_industry (code,name,state,parent_code) values ('1783','纺织带和帘子布制造',1,'178');
insert into t_industry (code,name,state,parent_code) values ('1784','篷、帆布制造',1,'178');
insert into t_industry (code,name,state,parent_code) values ('1789','其他产业用纺织制成品制造',1,'178');
insert into t_industry (code,name,state,parent_code) values ('18','纺织服装、服饰业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('181','机织服装制造',1,'18');
insert into t_industry (code,name,state,parent_code) values ('1811','运动机织服装制造',1,'181');
insert into t_industry (code,name,state,parent_code) values ('1819','其他机织服装制造',1,'181');
insert into t_industry (code,name,state,parent_code) values ('182','针织或钩针编织服装制造',1,'18');
insert into t_industry (code,name,state,parent_code) values ('1821','运动休闲针织服装制造',1,'182');
insert into t_industry (code,name,state,parent_code) values ('1829','其他针织或钩针编织服装制造',1,'182');
insert into t_industry (code,name,state,parent_code) values ('1830','服饰制造',1,'18');
insert into t_industry (code,name,state,parent_code) values ('19','皮革、毛皮、羽毛及其制品和制鞋业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('1910','皮革鞣制加工',1,'19');
insert into t_industry (code,name,state,parent_code) values ('192','皮革制品制造',1,'19');
insert into t_industry (code,name,state,parent_code) values ('1921','皮革服装制造',1,'192');
insert into t_industry (code,name,state,parent_code) values ('1922','皮箱、包(袋)制造',1,'192');
insert into t_industry (code,name,state,parent_code) values ('1923','皮手套及皮装饰制品制造 ',1,'192');
insert into t_industry (code,name,state,parent_code) values ('1929','其他皮革制品制造',1,'192');
insert into t_industry (code,name,state,parent_code) values ('193','毛皮鞣制及制品加工',1,'19');
insert into t_industry (code,name,state,parent_code) values ('1931','毛皮鞣制加工',1,'193');
insert into t_industry (code,name,state,parent_code) values ('1932','毛皮服装加工',1,'193');
insert into t_industry (code,name,state,parent_code) values ('1939','其他毛皮制品加工',1,'193');
insert into t_industry (code,name,state,parent_code) values ('194','羽毛(绒)加工及制品制造',1,'19');
insert into t_industry (code,name,state,parent_code) values ('1941','羽毛(绒)加工',1,'194');
insert into t_industry (code,name,state,parent_code) values ('1942','羽毛(绒)制品加工',1,'194');
insert into t_industry (code,name,state,parent_code) values ('195','制鞋业',1,'19');
insert into t_industry (code,name,state,parent_code) values ('1951','纺织面料鞋制造',1,'195');
insert into t_industry (code,name,state,parent_code) values ('1952','皮鞋制造',1,'195');
insert into t_industry (code,name,state,parent_code) values ('1953','塑料鞋制造',1,'195');
insert into t_industry (code,name,state,parent_code) values ('1954','橡胶鞋制造',1,'195');
insert into t_industry (code,name,state,parent_code) values ('1959','其他制鞋业',1,'195');
insert into t_industry (code,name,state,parent_code) values ('20','木材加工和木、竹、藤、棕、草制品业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('201','木材加工',1,'20');
insert into t_industry (code,name,state,parent_code) values ('2011','锯材加工',1,'201');
insert into t_industry (code,name,state,parent_code) values ('2012','木片加工',1,'201');
insert into t_industry (code,name,state,parent_code) values ('2013','单板加工',1,'201');
insert into t_industry (code,name,state,parent_code) values ('2019','其他木材加工',1,'201');
insert into t_industry (code,name,state,parent_code) values ('202','人造板制造',1,'20');
insert into t_industry (code,name,state,parent_code) values ('2021','胶合板制造',1,'202');
insert into t_industry (code,name,state,parent_code) values ('2022','纤维板制造',1,'202');
insert into t_industry (code,name,state,parent_code) values ('2023','刨花板制造',1,'202');
insert into t_industry (code,name,state,parent_code) values ('2029','其他人造板制造',1,'202');
insert into t_industry (code,name,state,parent_code) values ('203','木制品制造',1,'20');
insert into t_industry (code,name,state,parent_code) values ('2031','建筑用木料及木材组件加工',1,'203');
insert into t_industry (code,name,state,parent_code) values ('2032','木门窗制造',1,'203');
insert into t_industry (code,name,state,parent_code) values ('2033','木楼梯制造',1,'203');
insert into t_industry (code,name,state,parent_code) values ('2034','木地板制造',1,'203');
insert into t_industry (code,name,state,parent_code) values ('2035','木制容器制造',1,'203');
insert into t_industry (code,name,state,parent_code) values ('2039','软木制品及其他木制品制造',1,'203');
insert into t_industry (code,name,state,parent_code) values ('204','竹、藤、棕、草制品制造',1,'20');
insert into t_industry (code,name,state,parent_code) values ('2041','竹制品制造',1,'204');
insert into t_industry (code,name,state,parent_code) values ('2042','藤制品制造',1,'204');
insert into t_industry (code,name,state,parent_code) values ('2043','棕制品制造',1,'204');
insert into t_industry (code,name,state,parent_code) values ('2049','草及其他制品制造',1,'204');
insert into t_industry (code,name,state,parent_code) values ('21','家具制造业 ',1,'C');
insert into t_industry (code,name,state,parent_code) values ('2110','木质家具制造',1,'21');
insert into t_industry (code,name,state,parent_code) values ('2120','竹、藤家具制造',1,'21');
insert into t_industry (code,name,state,parent_code) values ('2130','金属家具制造',1,'21');
insert into t_industry (code,name,state,parent_code) values ('2140','塑料家具制造',1,'21');
insert into t_industry (code,name,state,parent_code) values ('2190','其他家具制造',1,'21');
insert into t_industry (code,name,state,parent_code) values ('22','造纸和纸制品业 ',1,'C');
insert into t_industry (code,name,state,parent_code) values ('221','纸浆制造',1,'22');
insert into t_industry (code,name,state,parent_code) values ('2211','木竹浆制造',1,'221');
insert into t_industry (code,name,state,parent_code) values ('2212','非木竹浆制造',1,'221');
insert into t_industry (code,name,state,parent_code) values ('222','造纸',1,'22');
insert into t_industry (code,name,state,parent_code) values ('2221','机制纸及纸板制造',1,'222');
insert into t_industry (code,name,state,parent_code) values ('2222','手工纸制造',1,'222');
insert into t_industry (code,name,state,parent_code) values ('2223','加工纸制造',1,'222');
insert into t_industry (code,name,state,parent_code) values ('223','纸制品制造',1,'22');
insert into t_industry (code,name,state,parent_code) values ('2231','纸和纸板容器制造',1,'223');
insert into t_industry (code,name,state,parent_code) values ('2239','其他纸制品制造',1,'223');
insert into t_industry (code,name,state,parent_code) values ('23','印刷和记录媒介复制业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('231','印刷',1,'23');
insert into t_industry (code,name,state,parent_code) values ('2311','书、报刊印刷',1,'231');
insert into t_industry (code,name,state,parent_code) values ('2312','本册印制',1,'231');
insert into t_industry (code,name,state,parent_code) values ('2319','包装装潢及其他印刷',1,'231');
insert into t_industry (code,name,state,parent_code) values ('2320','装订及印刷相关服务',1,'23');
insert into t_industry (code,name,state,parent_code) values ('2330','记录媒介复制',1,'23');
insert into t_industry (code,name,state,parent_code) values ('24','文教、工美、体育和娱乐用品制造业',1,'C');
insert into t_industry (code,name,state,parent_code) values ('241','文教办公用品制造',1,'24');
insert into t_industry (code,name,state,parent_code) values ('2411','文具制造',1,'241');
insert into t_industry (code,name,state,parent_code) values ('2412','笔的制造',1,'241');
insert into t_industry (code,name,state,parent_code) values ('2413','教学用模型及教具制造',1,&