MySql建表语句，教师，学生，班级

最新推荐文章于 2025-07-08 20:11:52 发布

原创最新推荐文章于 2025-07-08 20:11:52 发布 · 3.5k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

笔记同时被 2 个专栏收录

5 篇文章

订阅专栏

教师学生班级

1 篇文章

订阅专栏

由于未提供博客具体内容，无法给出包含关键信息的摘要。

DROP DATABASE IF EXISTS Teach;
CREATE DATABASE Teach  DEFAULT CHARACTER SET utf8;
USE Teach;

CREATE TABLE class (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(255) DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
INSERT INTO class VALUES(01,'class1');
INSERT INTO class VALUES(02,'class2');

CREATE TABLE teacher (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(255) DEFAULT NULL,
  cid int(11) DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
INSERT INTO teacher VALUES(01,'teacher1',01);
INSERT INTO teacher VALUES(02,'teacher2',01);
INSERT INTO teacher VALUES(03,'teacher3',02);
INSERT INTO teacher VALUES(04,'teacher4',02);

CREATE TABLE student (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(255) DEFAULT NULL,
  cid int(11) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY fk_student_class (cid)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
INSERT INTO student VALUES(01,'student1',01);
INSERT INTO student VALUES(02,'student2',01);
INSERT INTO student VALUES(03,'student3',01);
INSERT INTO student VALUES(04,'student4',01);
INSERT INTO student VALUES(05,'student5',02);
INSERT INTO student VALUES(06,'student6',02);
INSERT INTO student VALUES(07,'student7',02);
INSERT INTO student VALUES(08,'student8',02);

CREATE TABLE stuteach (
  id int(11) NOT NULL AUTO_INCREMENT,
  sid int(11) DEFAULT NULL,
  tid int(11) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY fk_stuteach_student (sid),
  KEY fk_stuteach_teacher (tid)
)ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
INSERT INTO stuteach VALUES(01,01,01);
INSERT INTO stuteach VALUES(02,02,01);
INSERT INTO stuteach VALUES(03,03,01);
INSERT INTO stuteach VALUES(04,04,01);
INSERT INTO stuteach VALUES(05,05,02);
INSERT INTO stuteach VALUES(06,06,02);
INSERT INTO stuteach VALUES(07,07,02);
INSERT INTO stuteach VALUES(08,08,02);
select * from stuteach;