数据库和表:
course(课程表):
sc(分数表):
student(学生信息表):
teacher(老师信息表):
顺便附上SQL语句自己去生成,练习
CREATE DATABASE /*!32312 IF NOT EXISTS*/`school` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `school`;
/*Table structure for table `course` */
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`CID` varchar(10) DEFAULT NULL,
`Cname` varchar(10) DEFAULT NULL,
`TID` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `course` */
insert into `course`(`CID`,`Cname`,`TID`) values ('01','语文','02'),('02','数学','01'),('03','英语','03');
/*Table structure for table `sc` */
DROP TABLE IF EXISTS `sc`;
CREATE TABLE `sc` (
`SID` varchar(10) DEFAULT NULL,
`CID` varchar(10) DEFAULT NULL,
`score` decimal(18,1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `sc` */
insert into `sc`(`SID`,`CID`,`score`) values ('01','01','80.0'),('01','02','90.0'),('01','03','99.0'),('02','01','70.0'),('02','02','60.0'),('02','03','80.0'),('03','01','80.0'),('03','02','80.0'),('03','03','80.0'),('04','01','50.0'),('04','02','30.0'),('04','03','20.0'),('05','01','76.0'),('05','02','87.0'),('06','01','31.0'),('06','03','34.0'),('07','02','89.0'),('07','03','98.0');
/*Table structure for table `student` */
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`SID` varchar(10) DEFAULT NULL,
`Sname` varchar(10) DEFAULT NULL,
`Sage` datetime DEFAULT NULL,
`Ssex` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `student` */
insert into `student`(`SID`,`Sname`,`Sage`,`Ssex`) values ('01','赵雷','1990-01-01 00:00:00','男'),('02','钱电','1990-12-21 00:00:00','男'),('03','孙风','1990-05-20 00:00:00','男'),('04','李云','1990-08-06 00:00:00','男'),('05','周梅','1991-12-01 00:00:00','女'),('06','吴兰','1992-03-01 00:00:00','女'),('07','郑竹','1989-07-01 00:00:00','女'),('08','王菊','1990-01-20 00:00:00','女');
/*Table structure for table `teacher` */
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
`TID` varchar(10) DEFAULT NULL,
`Tname` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `teacher` */
insert into `teacher`(`TID`,`Tname`) values ('01','张三'),('02','李四'),('03','王五');
下面附上图片,自己慢慢自己看
仔细看完这些并弄懂后,就算mysql还不是很精通,但是至少也能玩转查询了吧。
各位大兄弟,若这样都不懂的话,答应我,那个不要也罢,剁了。
以前从网上找的,保存很久了,也不知道谁的了,就不附转了。