INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('A','','农、林、牧、渔业','本门类包括 01～05 大类'); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('01','A','农业','指对各种农作物的种植'); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('011','01','谷物种植','指以收获籽实为主的农作物的种植，包括稻谷、小麦、玉米等农作物的种植和作为饲料和工业原料的谷物的种植'); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0111','011','稻谷种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0112','011','小麦种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0113','011','玉米种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0119','011','其他谷物种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('012','01','豆类、油料和薯类种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0121','012','豆类种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0122','012','油料种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0123','012','薯类种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('013','01','棉、麻、糖、烟草种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0131','013','棉花种植',''); INSERT INTO INDUSTRYS (HY_KEY,HY_PKEY,HY_MC,HY_SM) VALUES ('0132','013','麻类种植','');

2017年 国民经济行业分类SQL语句，包含行业说明信息。

国家行业分类数据库mysql版本

国家标准行业分类，2017年的数据，有几千条数据，人工在前端添加基本不现实，一般是通过数据库的方式调取，分享给各位猿友。 部分内容展示 -- ---------------------------- -- Table structure for `industrys` -- ---------------------------- DROP TABLE IF EXISTS `industrys`; CREATE TABLE `industrys` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(300) NOT NULL DEFAULT '' COMMENT '行业名称', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父id', `created_at` int(11) DEFAULT NULL, `updated_at` int(11) DEFAULT NULL, `deleted_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1046694 DEFAULT CHARSET=utf8 COMMENT='行业表'; -- ---------------------------- -- Records of industrys -- ---------------------------- INSERT INTO `industrys` VALUES ('1', '农业', '0', null, null, null); INSERT INTO `industrys` VALUES ('2', '食品、饮料', '0', null, null, null); INSERT INTO `industrys` VALUES ('3', '服装', '0', null, null, null); INSERT INTO `industrys` VALUES ('4', '纺织、皮革', '0', null, null, null); INSERT INTO `industrys` VALUES ('5', '电工电气', '0', null, null, null); INSERT INTO `industrys` VALUES ('6', '家用电器', '0', null, null, null); INSERT INTO `industrys` VALUES ('7', '数码、电脑', '0', null, null, null); INSERT INTO `industrys` VALUES ('8', '化工', '0', null, null, null); INSERT INTO `industrys` VALUES ('9', '冶金矿产', '0', null, null, null); INSERT INTO `industrys` VALUES ('10', '能源', '0', null, null, null); INSERT INTO `industrys` VALUES ('11', '环保', '0', null, null, null); INSERT INTO `industrys` VALUES ('12', '交通运输', '0', null, null, null);