代码拉取完成,页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : 连接mysql
Source Server Type : MySQL
Source Server Version : 80028
Source Host : localhost:3306
Source Schema : stu_grade
Target Server Type : MySQL
Target Server Version : 80028
File Encoding : 65001
Date: 05/04/2022 16:20:53
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`stu_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`stu_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`stu_sex` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`chinese` double(32, 0) NOT NULL,
`math` double(32, 0) NOT NULL,
`english` double(32, 0) NOT NULL,
`sci_total` double(32, 0) NOT NULL,
`total` double(32, 0) NOT NULL,
PRIMARY KEY (`stu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('4', '4', '男', 4, 4, 4, 100, 112);
INSERT INTO `student` VALUES ('5001190111', 'jack', '男', 98, 99, 100, 300, 597);
INSERT INTO `student` VALUES ('50011901157', '张三', '男', 100, 1, 1, 1, 103);
INSERT INTO `student` VALUES ('500119011X', 'tom', '女', 98, 99, 100, 280, 0);
INSERT INTO `student` VALUES ('6', '6', '6', 6, 6, 6, 6, 6);
INSERT INTO `student` VALUES ('7', '7', '女', 7, 7, 7, 7, 28);
INSERT INTO `student` VALUES ('8', '8', '8', 8, 8, 8, 8, 8);
-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
`tec_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`tec_pwd` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
PRIMARY KEY (`tec_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('123', '321', '张三');
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。