全面掌握MySQL：学生课程管理系统的实战演练资源-CSDN下载

需积分: 5 43 浏览量 2024-08-31 11:01:38 上传评论收藏 27KB DOCX 举报

资源推荐

资源详情

资源评论

CREATE TABLE `course` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`teacher_id` int(11) NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE,

INDEX `teacher_id`(`teacher_id`) USING BTREE,

CONSTRAINT `course_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `teacher` (`id`) ON DELETE

RESTRICT ON UPDATE RESTRICT

) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT

= '课程' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Records of course

-- ----------------------------

INSERT INTO `course` VALUES (1, '语文', 1);

INSERT INTO `course` VALUES (2, '数学', 1);

INSERT INTO `course` VALUES (3, '生物', 2);

INSERT INTO `course` VALUES (4, '化学', 2);

INSERT INTO `course` VALUES (5, '物理', 2);

INSERT INTO `course` VALUES (6, '英语', 3);

-- ----------------------------

-- Table structure for student

-- ----------------------------

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`city` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`age` int(11) NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT

= '学生' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Records of student

-- ----------------------------

INSERT INTO `student` VALUES (1, '小王', '北京', 20);

INSERT INTO `student` VALUES (2, '小李', '上海', 18);

INSERT INTO `student` VALUES (3, '小周', '北京', 22);

INSERT INTO `student` VALUES (4, '小刘', '北京', 21);

INSERT INTO `student` VALUES (5, '小张', '上海', 22);

INSERT INTO `student` VALUES (6, '小赵', '北京', 17);

INSERT INTO `student` VALUES (7, '小蒋', '上海', 23);

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余6页未读，立即下载

内容反馈

菀星鋶

粉丝: 969

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip