MySql 学校机房实验上机开始操作

CREATE DATABASE  IF NOT EXISTS `teaching` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `teaching`;
-- MySQL dump 10.13  Distrib 8.0.29, for Win64 (x86_64)
--
-- Host: localhost    Database: teaching
-- ------------------------------------------------------
-- Server version    8.0.29

/*!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 utf8 */;
/*!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 `c`
--

DROP TABLE IF EXISTS `c`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `c` (
  `cno` char(10) NOT NULL COMMENT '课程号',
  `cn` varchar(20) NOT NULL COMMENT '课程名',
  `ct` int NOT NULL COMMENT ' 学时'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `c`
--

LOCK TABLES `c` WRITE;
/*!40000 ALTER TABLE `c` DISABLE KEYS */;
INSERT INTO `c` VALUES ('c1','java程序设计',40),('c2','程序设计基础',48),('c3','线性代数',48),('c4','数据结构',64),('c5','数据库系统',56),('c6','数据挖掘',32),('c7','高等数学',60),('c8','控制理论',32);
/*!40000 ALTER TABLE `c` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `s`
--

DROP TABLE IF EXISTS `s`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `s` (
  `sno` char(10) NOT NULL COMMENT '学号',
  `sn` varchar(20) DEFAULT NULL COMMENT '姓名',
  `sex` enum('男','女') DEFAULT '男' COMMENT '性别',
  `age` int DEFAULT NULL COMMENT '年龄',
  `maj` varchar(20) NOT NULL COMMENT '专业',
  `dept` varchar(20) NOT NULL COMMENT '院系',
  PRIMARY KEY (`sno`),
  UNIQUE KEY `sn` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `s`
--

LOCK TABLES `s` WRITE;
/*!40000 ALTER TABLE `s` DISABLE KEYS */;
INSERT INTO `s` VALUES ('s1','王彤','女',18,'计算机','信息学院'),('s2','苏乐','女',20,'信息','信息学院'),('s3','林昕','男',19,'信息','信息学院'),('s4','陶然','女',18,'自动化','工学院'),('s5','魏立','男',17,'数学','理学院'),('s6','何欣荣','女',21,'计算机','信息学院'),('s7','赵琳琳','女',19,'数学','理学院'),('s8','李轩','男',19,'自动化','工学院');
/*!40000 ALTER TABLE `s` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sc`
--

DROP TABLE IF EXISTS `sc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sc` (
  `sno` char(10) NOT NULL COMMENT '学号',
  `cno` varchar(10) NOT NULL COMMENT '课程号',
  `score` float DEFAULT NULL COMMENT '成绩'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sc`
--

LOCK TABLES `sc` WRITE;
/*!40000 ALTER TABLE `sc` DISABLE KEYS */;
INSERT INTO `sc` VALUES ('s1','c1',90.5),('s1','c2',85),('s2','c5',57),('s2','c6',81.5),('s2','c7',88),('s2','c4',70),('s3','c1',75),('s3','c2',70.5),('s3','c4',85),('s4','c1',93),('s4','c2',85),('s4','c3',83),('s4','c6',88),('s5','c2',89),('s5','c7',60),('s7','c2',62),('s7','c5',80),('s7','c7',100),('s8','c3',96),('s8','c7',78.5);
/*!40000 ALTER TABLE `sc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t`
--

DROP TABLE IF EXISTS `t`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t` (
  `tno` char(10) NOT NULL COMMENT '教师号',
  `tn` varchar(20) DEFAULT NULL COMMENT '姓名',
  `sex` enum('男','女') DEFAULT '男' COMMENT '性别',
  `age` int DEFAULT NULL COMMENT '年龄',
  `prof` enum('讲师','副教授','教授') DEFAULT '讲师' COMMENT '职称',
  `sal` float NOT NULL COMMENT '工资',
  `maj` varchar(20) NOT NULL COMMENT '专业',
  `dept` varchar(20) NOT NULL COMMENT '院系',
  UNIQUE KEY `tn` (`tn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t`
--

LOCK TABLES `t` WRITE;
/*!40000 ALTER TABLE `t` DISABLE KEYS */;
INSERT INTO `t` VALUES ('t1','刘杨','男',40,'教授',3610.5,'计算机','信息学院'),('t2','石丽','女',26,'讲师',2923.3,'信息','信息学院'),('t3','顾伟','男',32,'副教授',3145,'计算机','信息学院'),('t4','赵礼','女',50,'教授',4267.5,'自动化','工学院'),('t5','赵希希','女',36,'副教授',3332.67,'数学','理学院'),('t6','张刚','男',30,'讲师',3012,'自动化','工学院');
/*!40000 ALTER TABLE `t` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tc`
--

DROP TABLE IF EXISTS `tc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tc` (
  `tno` char(10) NOT NULL COMMENT '教师号',
  `cno` varchar(10) NOT NULL COMMENT '课程号',
  `tcdate` date NOT NULL COMMENT '开课日期'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tc`
--

LOCK TABLES `tc` WRITE;
/*!40000 ALTER TABLE `tc` DISABLE KEYS */;
INSERT INTO `tc` VALUES ('t1','c1','2021-09-03'),('t1','c2','2021-09-04'),('t2','c5','2021-09-06'),('t2','c6','2021-09-10'),('t3','c2','2021-03-08'),('t3','c4','2021-03-06'),('t4','c3','2020-03-10'),('t5','c7','2020-03-09'),('t5','c8','2021-09-10');
/*!40000 ALTER TABLE `tc` 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 2022-10-13 11:19:49