```
SELECT s.name AS 姓名, c.name AS 课程名称, s.score AS 成绩, AVG(s.score) AS 平均成绩
FROM student s, course c
WHERE
2023-07-11 10:49
148
0
0
0
```
select stu_id,stu_name,AVG(score) from student inner join score on student.stu_id=score.stu_id where sco
2023-07-11 10:47
143
0
0
0
SELECT s.*,c.score
FROM student s
INNER JOIN course c
ON s.s_id=c.s_id
ORDER BY c.score DESC
LIMIT 1,
2023-07-11 10:44
137
0
0
0
SELECT teacher,AVG(score) AS avg_score
FROM course
GROUP BY teacher
ORDER BY avg_score DESC;
2023-07-11 10:44
141
0
0
0
SELECT * FROM student WHERE score
2023-07-11 10:43
142
0
0
0
centos定时备份mysql数据库并删除过期的（自己设定）备份
新建 mysql_autobackup.sh脚本，内容如下
```
#!/bin/bash
/usr/bin/mysqldump -uus
2023-07-11 10:43
162
0
0
0
SELECT stu_no FROM student_course WHERE course_no IN (SELECT course_no FROM student_course WHERE stu_no=01
2023-07-10 09:03
148
0
0
0
SELECT student_num,student_name FROM student_score WHERE course_score
2023-07-10 09:02
153
0
0
0