SAAS经营类目（2022-0926）导入mysql数据库

SAAS经营类目（2022-0926）导入mysql数据库

公司要对接第三方支付，于是类别导入这块就我接手了，由于没有现成的sql只能手动处理数据，头大，这里放出处理好的数据，有需要的自行取用

SAAS经营类目文件-----点击下载

image-1677548460977

数据库部分

image-1677548562682

数据库文件下载

代码部分

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mss_cmmt_mcc_code
-- ----------------------------
DROP TABLE IF EXISTS `mss_cmmt_mcc_code`;
CREATE TABLE `mss_cmmt_mcc_code`  (
  `mcc_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'mcc类目编码',
  `mcc_name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'mcc类目名称',
  `reference` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参考值',
  `parent_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级类目编码 一级类目默认0',
  PRIMARY KEY (`mcc_code`) USING BTREE,
  UNIQUE INDEX `mcc_code_UNIQUE`(`mcc_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'mcc码表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of mss_cmmt_mcc_code
-- ----------------------------
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0001', '餐饮', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010001', '地方菜', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010002', '创意菜', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010003', '面包房、糕点商店', '5462', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010004', '东南亚菜', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010005', '海鲜', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010006', '火锅', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010007', '家常菜', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010008', '包办伙食，宴会承包商', '5811', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010009', '咖啡厅', '5814', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010010', '烤鱼', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010011', '美食广场', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010012', '面馆', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010013', '日韩料理', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010014', '烧烤烤肉', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010015', '其他食品商店', '5499', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010016', '食堂', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010017', '素食', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010018', '汤/粥/炖菜', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010019', '西餐', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010020', '快餐店', '5814', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010021', '小龙虾', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010022', '其他餐饮', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010023', '休闲茶饮', '5499', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010024', '糖果及坚果商店', '5441', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00010025', '就餐场所和餐馆', '5812', '0001');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0002', '零售', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020001', '各类杂货店、便利店', '5331', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020002', '窗帘、遮阳棚商店', '5714', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020003', '纺织品及针织品零售', '5949', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020004', '综合性超级市场', '5411', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020005', '家用电器商店', '5722', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020006', '二手车经销商', '5521', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020007', '旧货及二手商品店', '5931', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020008', '其他服饰商店', '5699', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020009', '草坪、园艺用品商店', '5261', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020010', '化妆品', '5977', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020011', '银器店', '5944', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020012', '礼品、纪念品、节日装饰品商店', '5947', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020013', '家具及家居生活用品', '5712', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020014', '家庭装饰用品商店', '5719', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020015', '家用电器', '5722', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020016', '五金商店', '5251', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020017', '建材销售', '5211', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020018', '服装出租', '7296', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020019', '瓶装酒零售店', '5921', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020020', '运动服饰商店', '5655', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020021', '智能家居', '5722', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020022', '其他综合零售服务', '5399', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020023', '贵重珠宝、首饰、钟表零售', '5094', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020024', '综合商场', '5999', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020025', '景区购物', '7999', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020026', '汽车经销商', '5511', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020027', '化妆品商店', '5977', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020028', '百货商店', '5311', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020029', '肉类水产商店', '5422', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020030', '乳制品商店', '5451', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020031', '香烟、雪茄专卖店', '5993', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020032', '男装商店', '5611', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020033', '女装商店', '5621', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020034', '女性饰品商店', '5631', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020035', '服装综合零售店', '5651', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020036', '鞋店', '5661', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020037', '皮货店', '5681', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020038', '成人成衣店', '5691', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020039', '服装定制及修补改衣店', '5697', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020040', '假发商店', '5698', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020041', '箱包、皮具店', '5948', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020042', '玻璃、陶瓷、水晶制品商店', '5950', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020043', '邮票和纪念币商店', '5972', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020044', '宗教用品商店', '5973', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020045', '助听器销售', '5975', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020046', '光学仪器、眼镜店', '8043', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020047', '音像制品商店与音像产品下载', '5735', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020048', '古玩复制店', '5937', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020049', '自行车商店', '5940', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020050', '运动器材装备商店', '5941', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020051', '书店', '5942', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020052', '文具商店', '5943', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020053', '玩具店', '5945', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020054', '报亭、报摊', '5994', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020055', '医疗器械', '5976', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020056', '活动房屋销售商', '5271', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020057', '汽车轮胎经销商', '5532', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020058', '自助加油站', '5542', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020059', '船只经销商', '5551', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020060', '拖车销售商', '5561', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020061', '房车销售商', '5592', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020062', '雪车商', '5598', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020063', '燃料经销商（除机动车燃料）', '5983', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020064', '其他机动车、飞行器、农业机械经销商', '5599', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020065', '通讯设备销售', '4812', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020066', '电子设备商店', '5732', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020067', '计算机软件商店与软件下载', '5734', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020068', '打字机商店－销售、服务和出租', '5978', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020069', '电动剃刀商店－销售和服务', '5997', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020070', '玻璃、油漆涂料、墙纸零售', '5231', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020071', '地板、地毯商店', '5713', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020072', '壁炉、壁炉防护网及配件商店', '5718', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020073', '花店', '5992', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020074', '免税商店', '5309', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00020075', '折扣商店', '5310', '0002');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0003', '休闲娱乐', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030001', '工艺美术商店', '5970', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030002', '歌舞厅、卡拉OK', '7911', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030003', 'VR', '7994', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030004', '采摘/农家乐', '7999', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030005', '电影院', '7832', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030006', '儿童乐园', '7996', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030007', '轰趴馆', '7999', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030008', '休闲饮品场所、酒吧、咖啡厅、茶馆', '5813', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030009', '剧场/影院', '7832', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030010', '游乐园、马戏馆、嘉年华', '7996', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030011', '大型游戏机和游戏场所', '7994', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030012', '热门演出', '7991', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030013', '赛事展览', '7991', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030014', '动物园、海洋馆', '7998', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030015', '私人影院', '7832', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030016', '团建拓展', '7994', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030017', '电子游戏设备销售', '7993', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030018', '按摩足疗店', '7297', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030019', '乐器商店', '5733', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030020', '洗浴/汗蒸', '7297', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030021', '舞台演出服务及票务', '7922', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030022', '养生', '7297', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030023', '艺术商和画廊', '5971', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030024', '音乐厅/礼堂', '7911', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030025', '游乐场所', '7994', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030026', '真人CS', '7999', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030027', '桌面游戏', '7994', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030028', '足疗按摩', '7297', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030029', '集体活动服务商，夏令营、拓展训练', '7032', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030030', '宿营场地', '7033', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030031', '影视、音像制品创作、发行', '7829', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00030032', '会员制体育健身俱乐部、会所', '7997', '0003');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0004', '居民服务', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040001', '物流服务', '4214', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040002', '会计、审计、财务服务', '8931', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040003', '彩票销售', '7995', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040004', '彩妆造型', '7230', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040005', '公共事业（电力、煤气、自来水、清洁服务）', '4900', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040006', '其他专门零售店', '5999', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040007', '其他个人服务', '7299', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040008', '宠物商店、宠物食品及用品', '5995', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040009', '其他计算机维护和修理服务', '7379', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040010', '儿童运动馆', '7994', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040011', '摄影摄像器材商店', '5946', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040012', '家政服务', '7295', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040013', '古玩艺术品销售', '5932', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040014', '婚庆公司', '7273', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040015', '婚恋服务与婚庆公司', '7273', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040016', '商业摄影、平面设计', '7333', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040017', '加油、加气、充电站', '5541', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040018', '电器设备维修', '7622', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040019', '家具定制', '5712', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040020', '室内清洁服务', '7217', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040021', '本市和市郊通勤旅客运输（包括轮渡）', '4111', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040023', '开奶催乳', '7295', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040024', '开锁换锁', '7295', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040025', '美甲美睫', '7230', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040026', '美容、美发', '7230', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040027', '理发店', '7230', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040028', '母婴店', '5641', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040029', '婴儿、儿童服装店', '5641', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040030', '殡葬、墓地服务', '7261', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040031', '商圈，智慧商街', '5999', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040032', '法律事务', '8111', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040033', '社区服务', '8641', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040034', '照相馆、摄影工作室', '7221', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040035', '生活缴费', '7299', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040036', '快递公司', '4215', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040037', '收费站', '4784', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040038', '其他维修服务', '7699', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040039', '售票点', '4733', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040040', '停车场', '7523', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040041', '电信运营商', '4814', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040042', '其他专业服务', '8999', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040043', '其他文艺表演、艺术创作', '7929', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040044', '纹身', '8011', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040045', '铁路货运服务', '4011', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040046', '物业管理', '6513', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040047', '洗衣店', '7210', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040048', '养老院', '8398', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040049', '游泳池－销售、供应和服务', '5996', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040050', '月嫂', '7295', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040051', '月子会所', '7295', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040052', '照片冲印/图文文印', '7221', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040053', '装修装潢服务', '8912', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040054', '宠物医院', '742', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040055', '住宅与商业地产开发商', '1520', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040057', '计算机软件开发、系统集成、数据处理服务', '7372', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040058', '保险行业', '6300', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040059', '职业介绍与人才服务', '7361', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040060', '自助洗衣服务', '7211', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040061', '干洗店', '7216', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00040062', '照片洗印服务', '7395', '0004');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0005', '医疗', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050001', '公共卫生服务机构', '8099', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050002', '医疗护理和看护服务', '8050', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050003', '牙科诊所', '8021', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050004', '其他医疗机构', '8011', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050005', '药房、药店', '5912', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050006', '医院', '8062', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050007', '诊所', '8011', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050008', '整形', '8011', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00050009', '中医', '8062', '0005');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0006', '教育', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00060001', '其他学校和教育服务', '8299', '0006');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00060002', '函授学校（成人教育）', '8241', '0006');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00060003', '学前教育', '8351', '0006');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00060004', '幼儿教育', '8351', '0006');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00060005', '中小学校', '8211', '0006');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00060006', '商业和文秘学校', '8244', '0006');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00060007', '职业技能培训', '8249', '0006');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0007', '批发', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070001', '其他批发商', '5998', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070002', '烟草配送', '7458', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070003', '办公及商务家具批发', '5021', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070004', '建筑装饰材料批发', '5039', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070005', '办公设备批发商', '5044', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070006', '计算机及外设批发', '5045', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070007', '医疗器械批发', '5047', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070008', '金属材料批发', '5051', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070009', '电器零件与通信器材批发', '5065', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070010', '五金批发', '5072', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070011', '管道与供暖设备批发', '5074', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070012', '文教用品批发', '5111', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070013', '药品批发', '5122', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070014', '纺织原料及日用品批发', '5131', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070015', '服装、化妆品、卫生用品批发', '5137', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070016', '鞋帽批发', '5139', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070017', '石化产品批发', '5172', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070018', '书报批发', '5192', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070019', '花卉苗木批发', '5193', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070020', '涂料批发', '5198', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070021', '大型企业批发', '5398', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00070022', '其他商用机械设备批发', '5046', '0007');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0008', '汽车服务', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080001', '车体维修店', '7531', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080002', '洗车服务', '7542', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080003', '摩托车商店', '5571', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080004', '机动车、农机零配件批发', '5013', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080005', '保险代理', '6300', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080006', '汽车改装', '5521', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080007', '拖车服务', '7549', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080008', '路桥通行费', '7784', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080009', '汽车维修保养', '5511', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00080010', '汽车零配件商店', '5533', '0008');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0009', '旅游', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00090001', '动植物园', '7999', '0009');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00090002', '景点', '7999', '0009');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00090003', '景区管理', '7999', '0009');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00090004', '旅行社', '4722', '0009');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00090005', '景区售票', '4733', '0009');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00090006', '观光与会展服务', '7991', '0009');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0010', '出租和租赁服务', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100001', '出租车服务', '4121', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100002', '房产代理、经纪', '7013', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100003', '汽车出租', '7512', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100004', '其他娱乐服务', '7999', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100005', '出租船只', '4457', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100006', '码头、船只停泊与维修服务', '4468', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100007', '设备出租服务', '7394', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100008', '卡车、拖车与农机出租', '7513', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100009', '房车和娱乐车辆出租', '7519', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00100010', '音像制品出租服务', '7841', '0010');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0011', '健身运动', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110001', '保龄球馆', '7933', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110002', '壁球馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110003', '高尔夫球场', '7992', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110004', '滑雪场', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110005', '保健、美容及洗浴服务', '7298', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110006', '篮球场', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110007', '溜冰场', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110008', '马术场', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110009', '攀岩馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110010', '乒乓球馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110011', '射箭馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110012', '台球娱乐场所', '7932', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110013', '体育场馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110014', '网球馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110015', '武术场馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110016', '游泳馆', '5996', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110017', '瑜伽舞蹈', '7298', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110018', '羽毛球馆', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00110019', '运动比赛场馆、体育俱乐部、赛事推广', '7941', '0011');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0012', '酒店', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00120001', '连锁酒店', '7011', '0012');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00120002', '青年旅社', '7011', '0012');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00120003', '情侣酒店', '7011', '0012');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00120004', '住宿服务', '7011', '0012');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0013', '其他', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00130001', '其他', '5999', '0013');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00130002', '民办中小学、幼儿园业务', '8351', '0013');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00130003', '普通高校', '8220', '0013');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00130004', '农业合作社', '5261', '0013');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0014', '房地产业', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00140001', '建设工程', '1771', '0014');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0015', '交通运输、物流和仓储服务', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150001', '国家铁路总公司', '3998', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150002', '铁路客运', '4112', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150003', '救护车服务', '4119', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150004', '公路客运', '4131', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150005', '仓储服务', '4225', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150006', '旅客航运服务', '4411', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150007', '航空公司、航空客票销售', '4511', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150008', '机场、停机坪、飞机停靠与维修服务', '4582', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150009', '国家邮政服务', '9402', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00150010', '其他运输服务', '4789', '0015');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0016', '商业服务', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160001', '农业合作', '763', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160002', '景观美化及园艺服务', '780', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160003', '海上船只遇难救助', '5935', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160004', '税收准备服务', '7276', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160005', '个人咨询服务', '7277', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160006', '商品服务买卖居间活动、团购', '7278', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160007', '广告服务', '7311', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160008', '复印及绘图服务', '7338', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160009', '办公、文秘服务', '7339', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160010', '管理咨询与公共关系服务', '7392', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160011', '安全保卫服务', '7393', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160012', '汽车协会', '8675', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160013', '工业设计、建筑与工程设计', '8911', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00160014', '其他商业服务', '7399', '0016');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0017', '维修及其他专业服务', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170001', '兽医服务', '742', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170002', '鞋帽清洗保养服务', '7251', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170003', '灭虫及消毒服务', '7342', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170004', '保洁服务', '7349', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170005', '轮胎翻新、维修店', '7534', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170006', '汽车喷漆店', '7535', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170007', '机动车维修保养', '7538', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170008', '空调、制冷设备维修', '7623', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170009', '小家电维修', '7629', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170010', '手表、钟表和首饰维修店', '7631', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170011', '家具维修、翻新', '7641', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00170012', '焊接维修服务', '7692', '0017');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0018', '医生', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00180001', '正骨医生', '8031', '0018');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00180002', '按摩医生', '8041', '0018');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00180003', '眼科医生', '8042', '0018');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00180004', '手足病医生', '8049', '0018');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00180005', '医学检验与牙科设备服务', '8071', '0018');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('0019', '住宿业', '0', '0');
INSERT INTO `mss_cmmt_mcc_code` VALUES ('00190001', '分时度假房地产', '7012', '0019');

SET FOREIGN_KEY_CHECKS = 1;

欢迎关注博客，墨点白：https://nanwish.love/

posted @ 2023-02-28 11:01  孤水寒月  阅读(70)  评论(0)  编辑  收藏  举报