中华人民共和国国家标准标准(GB/T 4754—2017)
| 2017-06-30发布 2017-10-01实施 |
插入sql句子(修正后):
insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('A农、林、牧、渔业，null);insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) valuesA');insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('012','豆类、油料和薯类种植',1,'01');insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 013，棉、麻、糖、烟草种植，1,01；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (014，蔬菜、食用菌和园艺作物种植，1，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 insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0149','其他园艺作物种植',1,'014');insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0154，香蕉等亚热带水果种植，1，015)；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values ('0159','其他水果种植',1,'015');insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values坚果、含油果、香料和饮料作物种植，01；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0162，含油果种植，1，016)；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0163，香料作物种植，1，016)；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0169，其他饮料作物种植，1，016)；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 017，中草药种植，1，01；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values (0171，中草药种植，1，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 (0181，草种植，1，018)；insert into Industry (IndustryCode,IndustryName,IndustryState,ParentID) values 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,ParentID) 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,P