语句

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : casesql

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 28/04/2019 17:20:52
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for opencourses
-- ----------------------------
DROP TABLE IF EXISTS `opencourses`;
CREATE TABLE `opencourses`  (
  `month` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `course_id` int(10) DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of opencourses
-- ----------------------------
INSERT INTO `opencourses` VALUES ('200706', 1);
INSERT INTO `opencourses` VALUES ('200706', 3);
INSERT INTO `opencourses` VALUES ('200706', 4);
INSERT INTO `opencourses` VALUES ('200707', 4);
INSERT INTO `opencourses` VALUES ('200708', 2);
INSERT INTO `opencourses` VALUES ('200708', 4);

SET FOREIGN_KEY_CHECKS = 1;
/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : casesql

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 28/04/2019 17:21:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for coursemaster
-- ----------------------------
DROP TABLE IF EXISTS `coursemaster`;
CREATE TABLE `coursemaster`  (
  `course_id` int(11) NOT NULL,
  `course_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`course_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of coursemaster
-- ----------------------------
INSERT INTO `coursemaster` VALUES (1, '会计入门');
INSERT INTO `coursemaster` VALUES (2, '财务知识');
INSERT INTO `coursemaster` VALUES (3, '波及考试');
INSERT INTO `coursemaster` VALUES (4, '税务师');

SET FOREIGN_KEY_CHECKS = 1;