/* Navicat Premium Data Transfer Source Server : 本机 Source Server Type : MySQL Source Server Version : 50744 Source Host : localhost:3306 Source Schema : high-six-exam Target Server Type : MySQL Target Server Version : 50744 File Encoding : 65001 Date: 19/07/2024 08:51:38 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for day02_t_student -- ---------------------------- DROP TABLE IF EXISTS `day02_t_student`; CREATE TABLE `day02_t_student` ( `s_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生ID', `s_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学生姓名', `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学生性别', PRIMARY KEY (`s_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of day02_t_student -- ---------------------------- INSERT INTO `day02_t_student` VALUES (1, '韦秀英', '女'); INSERT INTO `day02_t_student` VALUES (2, '许晓明', '男'); INSERT INTO `day02_t_student` VALUES (3, '薛睿', '男'); INSERT INTO `day02_t_student` VALUES (4, '魏秀英', '女'); INSERT INTO `day02_t_student` VALUES (5, '尹杰宏', '男'); INSERT INTO `day02_t_student` VALUES (6, '阎岚', '女'); INSERT INTO `day02_t_student` VALUES (7, '姚秀英', '女'); INSERT INTO `day02_t_student` VALUES (8, '何致远', '男'); INSERT INTO `day02_t_student` VALUES (9, '徐嘉伦', '男'); INSERT INTO `day02_t_student` VALUES (10, '于嘉伦', '男'); INSERT INTO `day02_t_student` VALUES (11, '薛宇宁', '男'); INSERT INTO `day02_t_student` VALUES (12, '江晓明', '男'); INSERT INTO `day02_t_student` VALUES (13, '梁宇宁', '男'); INSERT INTO `day02_t_student` VALUES (14, '曹詩涵', '女'); INSERT INTO `day02_t_student` VALUES (15, '孟睿', '男'); INSERT INTO `day02_t_student` VALUES (16, '张子异', '男'); INSERT INTO `day02_t_student` VALUES (17, '龙子韬', '男'); INSERT INTO `day02_t_student` VALUES (18, '唐晓明', '男'); INSERT INTO `day02_t_student` VALUES (19, '何岚', '女'); INSERT INTO `day02_t_student` VALUES (20, '金璐', '女'); INSERT INTO `day02_t_student` VALUES (21, '蔡震南', '男'); INSERT INTO `day02_t_student` VALUES (22, '严云熙', '男'); INSERT INTO `day02_t_student` VALUES (23, '阎云熙', '男'); INSERT INTO `day02_t_student` VALUES (24, '邹震南', '男'); INSERT INTO `day02_t_student` VALUES (25, '郝致远', '男'); INSERT INTO `day02_t_student` VALUES (26, '姚云熙', '男'); INSERT INTO `day02_t_student` VALUES (27, '邱杰宏', '男'); INSERT INTO `day02_t_student` VALUES (28, '任璐', '女'); INSERT INTO `day02_t_student` VALUES (29, '蔡岚', '女'); INSERT INTO `day02_t_student` VALUES (30, '龙子韬', '男'); -- ---------------------------- -- Table structure for day02_t_course -- ---------------------------- DROP TABLE IF EXISTS `day02_t_course`; CREATE TABLE `day02_t_course` ( `c_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '课程ID', `c_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名称', PRIMARY KEY (`c_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of day02_t_course -- ---------------------------- INSERT INTO `day02_t_course` VALUES (1, '语文'); INSERT INTO `day02_t_course` VALUES (2, '数学'); INSERT INTO `day02_t_course` VALUES (3, '英语'); INSERT INTO `day02_t_course` VALUES (4, '生物'); INSERT INTO `day02_t_course` VALUES (5, '化学'); INSERT INTO `day02_t_course` VALUES (6, '物理'); -- ---------------------------- -- Table structure for day02_stu_cou -- ---------------------------- DROP TABLE IF EXISTS `day02_stu_cou`; CREATE TABLE `day02_stu_cou` ( `sc_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '选课ID', `c_id` int(11) NULL DEFAULT NULL COMMENT '选课课程', `s_id` int(11) NULL DEFAULT NULL COMMENT '选课学生', PRIMARY KEY (`sc_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of day02_stu_cou -- ---------------------------- INSERT INTO `day02_stu_cou` VALUES (1, 5, 9); INSERT INTO `day02_stu_cou` VALUES (2, 4, 25); INSERT INTO `day02_stu_cou` VALUES (3, 1, 3); INSERT INTO `day02_stu_cou` VALUES (4, 5, 3); INSERT INTO `day02_stu_cou` VALUES (5, 2, 11); INSERT INTO `day02_stu_cou` VALUES (6, 5, 4); INSERT INTO `day02_stu_cou` VALUES (7, 1, 1); INSERT INTO `day02_stu_cou` VALUES (8, 3, 20); INSERT INTO `day02_stu_cou` VALUES (9, 4, 26); INSERT INTO `day02_stu_cou` VALUES (10, 4, 27); INSERT INTO `day02_stu_cou` VALUES (11, 2, 14); INSERT INTO `day02_stu_cou` VALUES (12, 1, 8); INSERT INTO `day02_stu_cou` VALUES (13, 2, 12); INSERT INTO `day02_stu_cou` VALUES (14, 6, 17); INSERT INTO `day02_stu_cou` VALUES (15, 6, 16); INSERT INTO `day02_stu_cou` VALUES (16, 6, 15); INSERT INTO `day02_stu_cou` VALUES (17, 3, 23); INSERT INTO `day02_stu_cou` VALUES (18, 3, 24); INSERT INTO `day02_stu_cou` VALUES (19, 1, 5); INSERT INTO `day02_stu_cou` VALUES (20, 3, 18); INSERT INTO `day02_stu_cou` VALUES (21, 1, 6); INSERT INTO `day02_stu_cou` VALUES (22, 1, 7); INSERT INTO `day02_stu_cou` VALUES (23, 3, 17); INSERT INTO `day02_stu_cou` VALUES (24, 1, 4); INSERT INTO `day02_stu_cou` VALUES (25, 5, 6); INSERT INTO `day02_stu_cou` VALUES (26, 2, 13); INSERT INTO `day02_stu_cou` VALUES (27, 5, 5); INSERT INTO `day02_stu_cou` VALUES (28, 5, 8); INSERT INTO `day02_stu_cou` VALUES (29, 6, 20); INSERT INTO `day02_stu_cou` VALUES (30, 6, 13); INSERT INTO `day02_stu_cou` VALUES (31, 3, 19); INSERT INTO `day02_stu_cou` VALUES (32, 4, 28); INSERT INTO `day02_stu_cou` VALUES (33, 1, 2); INSERT INTO `day02_stu_cou` VALUES (34, 6, 14); INSERT INTO `day02_stu_cou` VALUES (35, 2, 16); INSERT INTO `day02_stu_cou` VALUES (36, 1, 10); INSERT INTO `day02_stu_cou` VALUES (37, 4, 29); INSERT INTO `day02_stu_cou` VALUES (38, 5, 7); INSERT INTO `day02_stu_cou` VALUES (39, 4, 30); INSERT INTO `day02_stu_cou` VALUES (40, 1, 9); INSERT INTO `day02_stu_cou` VALUES (41, 6, 18); INSERT INTO `day02_stu_cou` VALUES (42, 3, 21); INSERT INTO `day02_stu_cou` VALUES (43, 2, 15); INSERT INTO `day02_stu_cou` VALUES (44, 6, 30); INSERT INTO `day02_stu_cou` VALUES (45, 5, 11); INSERT INTO `day02_stu_cou` VALUES (46, 6, 19); INSERT INTO `day02_stu_cou` VALUES (47, 3, 22); INSERT INTO `day02_stu_cou` VALUES (48, 4, 2); INSERT INTO `day02_stu_cou` VALUES (49, 5, 12); INSERT INTO `day02_stu_cou` VALUES (50, 5, 10); SET FOREIGN_KEY_CHECKS = 1;