MYSQL语句

xyh200412

已于 2024-04-02 15:04:13 修改

阅读量66

点赞数 1

文章标签： mysql 前端 javascript

于 2024-04-02 14:56:25 首次发布

本文链接：https://blog.csdn.net/xyh200412/article/details/137270609

版权

select studentId,count(score)'考试科目数量',
sum(score )'学生成绩',
avg(score)'学生平均成绩'
from result INNER JOIN student;
GROUP BY studentId;

select studentId,userName,testName,score,introduce
from result right JOIN student on result.studentId=student.id;


select*from result INNER JOIN student on result.studentId=student .id;
select*from result left JOIN student on result.studentId=student .id;
select*from result right JOIN student on result.studentId=student .id;

DDL

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学号',
  `createDate` datetime DEFAULT NULL,
  `userName` varchar(20) DEFAULT NULL,
  `pwd` varchar(36) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `age` tinyint(3) unsigned DEFAULT NULL,
  `sex` char(2) DEFAULT '男',
  `introduce` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;