-- MySQL dump 10.13  Distrib 8.0.35, for Linux (x86_64)
--
-- Host: localhost    Database: scores
-- ------------------------------------------------------
-- Server version	8.0.35-0ubuntu0.23.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `student_scores`
--

DROP TABLE IF EXISTS `student_scores`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `student_scores` (
  `id` int NOT NULL AUTO_INCREMENT,
  `class` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `mid_term_chinese` int DEFAULT NULL,
  `mid_term_math` int DEFAULT NULL,
  `mid_term_english` int DEFAULT NULL,
  `final_term_chinese` int DEFAULT NULL,
  `final_term_math` int DEFAULT NULL,
  `final_term_english` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student_scores`
--

LOCK TABLES `student_scores` WRITE;
/*!40000 ALTER TABLE `student_scores` DISABLE KEYS */;
INSERT INTO `student_scores` VALUES (1,'23401','吴欢',72,56,71,43,21,60),(2,'23401','孙晓雨',23,14,27,41,30,38),(3,'23401','谭娜',73,88,76,59,85,62),(4,'23401','代宇搏',24,28,66,33,36,68),(5,'23401','卢宇',28,36,41,35,52,49),(6,'23401','孙善鹏',38,72,36,51,77,39),(7,'23401','庄潜',25,47,24,37,59,30),(8,'23401','李云强',34,29,34,44,73,38),(9,'23401','杨家豪',37,44,34,43,68,43),(10,'23401','顾荆峰',54,85,52,53,87,66),(11,'23401','谢圣杰',28,82,58,44,96,57),(12,'23401','刘慧颖',56,26,60,67,71,54),(13,'23401','毕雅雯',60,54,53,69,84,76),(14,'23401','许欣怡',58,8,65,53,29,77),(15,'23401','李锦燃',41,57,60,70,83,84),(16,'23401','李雨硕',53,29,36,52,53,65),(17,'23401','陈雨萱',70,68,90,72,97,91),(18,'23401','孟丹妮',45,26,27,41,54,45),(19,'23401','孟丹婷',38,40,35,48,54,33),(20,'23401','罗奥丹',59,65,53,58,82,63),(21,'23401','范琦',68,38,60,65,82,83),(22,'23401','蒯玲',38,51,45,55,80,53),(23,'23401','霍环婧',82,94,79,62,99,69),(24,'23401','刁飞虎',52,17,29,42,68,33),(25,'23401','李家衡',32,19,33,50,49,36),(26,'23401','徐志颖',69,86,38,59,100,88),(27,'23401','黄涵哲',67,91,84,79,99,89),(28,'23401','翟绍锋',25,16,30,44,50,34),(29,'23402','田怡然',58,57,69,50,73,80),(30,'23402','吴思萱',66,34,41,64,59,43),(31,'23402','吴馨硕',70,94,86,86,96,91),(32,'23402','张紫嫣',44,27,35,57,24,64),(33,'23402','张若男',36,15,33,38,15,24),(34,'23402','李佶阳',73,39,73,69,28,86),(35,'23402','沈可馨',25,35,37,42,13,61),(36,'23402','邱晨轩',62,39,32,57,51,62),(37,'23402','陈宣晔',53,17,35,55,22,50),(38,'23402','罗然',66,83,80,64,66,90),(39,'23402','胡雅琪',58,97,87,45,87,90),(40,'23402','管依婷',41,26,37,52,44,56),(41,'23402','马兆荣',51,43,39,47,50,71),(42,'23402','王子文',-4,22,37,34,15,56),(43,'23402','张洋',31,20,36,47,27,45),(44,'23402','张金涛',69,69,54,64,93,84),(45,'23402','张赵明皓',72,83,76,54,79,91),(46,'23402','李开弘',55,-4,53,43,28,-4),(47,'23402','李明科',74,67,71,57,54,58),(48,'23402','杨斌',63,73,56,46,44,61),(49,'23402','陈晨',34,33,35,62,44,51),(50,'23402','宗胜',65,53,60,35,21,31),(51,'23402','谭鑫浩',59,85,67,57,83,77),(52,'23402','周雨轩',55,6,34,51,12,23),(53,'23403','吕芳欣',14,25,28,13,16,54),(54,'23403','张珈源',31,28,41,37,58,29),(55,'23403','徐紫晴',52,38,45,64,69,74),(56,'23403','顾致钧',39,36,56,50,39,56),(57,'23403','方子瀚',59,52,57,55,66,62),(58,'23403','王启洺',54,34,43,58,84,81),(59,'23403','王潘宇',53,97,46,59,99,60),(60,'23403','任子翔',84,89,78,70,87,63),(61,'23403','范兴旺',29,17,22,15,12,18),(62,'23403','刘秋天',51,91,55,60,91,45),(63,'23403','闫名伟',32,77,61,53,86,44),(64,'23403','吴贝洋',45,52,44,59,61,56),(65,'23403','陈志刚',52,66,75,60,81,68),(66,'23403','陈哲仕',64,66,56,51,69,59),(67,'23403','俞得国',28,17,28,41,-4,-4),(68,'23403','施恩棋',29,83,39,29,91,30),(69,'23403','唐杰',72,72,67,50,90,46),(70,'23403','徐铭豪',36,41,39,51,74,41),(71,'23403','徐少浛',78,77,72,67,61,62),(72,'23403','秦磊',56,22,34,57,54,32),(73,'23403','吴雨轩',37,30,34,33,29,46),(74,'23403','钱语晨',57,55,66,48,63,60),(75,'23403','陈泽楷',65,30,72,59,69,80),(76,'23403','高圣智',31,22,31,49,41,22);
/*!40000 ALTER TABLE `student_scores` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-03-30 10:48:59
