技能抽查真的是一件比较烦心的事,接下来我们开看一道题目
以上是题目,下面我们来看一下解答过程
sql文件
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50725
Source Host : localhost:3306
Source Schema : harborbereau2
Target Server Type : MySQL
Target Server Version : 50725
File Encoding : 65001
Date: 19/11/2022 09:44:08
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_business_unit
-- ----------------------------
DROP TABLE IF EXISTS `t_business_unit`;
CREATE TABLE `t_business_unit` (
`business_unit_code` char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`short_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`business_unit_type` enum('国营经济','私营经济','个体经济','集体经济','股份制经济') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`business_unit_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_business_unit