本文共 2349 字,大约阅读时间需要 7 分钟。
1.班级表(t_class)
2.教师表(t_teacher) 3.学生表(t_student)CREATE TABLE `t_teacher` (`t_id` int(11) NOT NULL AUTO_INCREMENT,`t_name` varchar(20) DEFAULT NULL,PRIMARY KEY (`t_id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO `t_teacher` VALUES ('1', '刘晓云');INSERT INTO `t_teacher` VALUES ('2', '郑同华');INSERT INTO `t_teacher` VALUES ('3', '李明军');
CREATE TABLE `t_class` ( `c_id` int(11) NOT NULL AUTO_INCREMENT, `c_name` varchar(20) DEFAULT NULL, `teacher_id` int(11) DEFAULT NULL,PRIMARY KEY (`c_id`),KEY `fk_teacher_id` (`teacher_id`),CONSTRAINT `fk_teacher_id` FOREIGN KEY (`teacher_id`) REFERENCES `t_teacher` (`t_id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO `t_class` VALUES ('1', '2020软件1班', '3');INSERT INTO `t_class` VALUES ('2', '2020软件2班', '2');INSERT INTO `t_class` VALUES ('3', '2020软件3班', '1');
CREATE TABLE `t_student` ( `s_id` int(11) NOT NULL AUTO_INCREMENT, `s_name` varchar(30) DEFAULT NULL, `s_gender` varchar(10) DEFAULT NULL, `s_age` int(11) DEFAULT NULL, `class_id` int(11) DEFAULT NULL, PRIMARY KEY (`s_id`)) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
insert into t_student values('1','佟大为','男','20','1');insert into t_student values('2','李方玉','女','20','1');insert into t_student values('3','郑大林','男','20','2');insert into t_student values('4','温晓辉','女','20','1');insert into t_student values('5','吴文静','男','20','2');insert into t_student values('6','筱文艳','女','20','3');insert into t_student values('7','杨文军','男','20','3');insert into t_student values('8','唐语晗','女','20','2');insert into t_student values('9','金玉兴','男','20','2');
转载地址:http://ojtki.baihongyu.com/