You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
43 lines
1.8 KiB
43 lines
1.8 KiB
6 months ago
|
/*
|
||
|
|
Navicat Premium Data Transfer
|
||
|
|
|
||
|
|
Source Server : localhost_3306
|
||
|
|
Source Server Type : MySQL
|
||
|
|
Source Server Version : 80033
|
||
|
|
Source Host : localhost:3306
|
||
|
|
Source Schema : studentinfo
|
||
|
|
|
||
|
|
Target Server Type : MySQL
|
||
|
|
Target Server Version : 80033
|
||
|
|
File Encoding : 65001
|
||
|
|
|
||
|
|
Date: 03/06/2024 14:41:25
|
||
|
|
*/
|
||
|
|
|
||
|
|
SET NAMES utf8mb4;
|
||
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for stu_info
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `stu_info`;
|
||
|
|
CREATE TABLE `stu_info` (
|
||
|
|
`stu_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学生学号',
|
||
|
|
`stu_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学生姓名',
|
||
|
|
`stu_score_eng` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '英语成绩',
|
||
|
|
`stu_score_py` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'python成绩',
|
||
|
|
`stu_score_math` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '英语成绩',
|
||
|
|
`stu_sum_score` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '总成绩',
|
||
|
|
PRIMARY KEY (`stu_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Records of stu_info
|
||
|
|
-- ----------------------------
|
||
|
|
INSERT INTO `stu_info` VALUES ('202101', '张三', '86', '94', '96', '276');
|
||
|
|
INSERT INTO `stu_info` VALUES ('202105', '李四', '88', '93', '85', '266');
|
||
|
|
INSERT INTO `stu_info` VALUES ('202106', '王五', '84', '88', '90', '262');
|
||
|
|
INSERT INTO `stu_info` VALUES ('202107', '王茄子', '89', '92', '98', '279');
|
||
|
|
|
||
|
|
SET FOREIGN_KEY_CHECKS = 1;
|