16.试题编号：2-16 《码头中心船货申报系统》进出港船只申报模块----技能抽查

最新推荐文章于 2024-03-09 05:51:43 发布

VIP文章 lzf2025253413

最新推荐文章于 2024-03-09 05:51:43 发布

阅读量834

点赞数

文章标签：数据库 java mysql windows

本文链接：https://blog.csdn.net/lzf2025253413/article/details/127932756

版权

技能抽查真的是一件比较烦心的事，接下来我们开看一道题目

以上是题目，下面我们来看一下解答过程

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
-- ----------------------------
INSERT INTO &#