2023-07-11 10:47
127
0
0
0
```
select stu_id,stu_name,AVG(score) from student inner join score on student.stu_id=score.stu_id where score1;
```
2023-07-11 10:44
122
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,2;
2023-07-11 10:44
127
0
0
0
SELECT teacher,AVG(score) AS avg_score
FROM course
GROUP BY teacher
ORDER BY avg_score DESC;
2023-07-11 10:43
123
0
0
0
SELECT * FROM student WHERE score
2023-07-11 10:43
137
0
0
0
centos定时备份mysql数据库并删除过期的（自己设定）备份
新建 mysql_autobackup.sh脚本，内容如下
```
#!/bin/bash
/usr/bin/mysqldump -uusrname -ppassword databasename > /root/mysql_backup/mysql_$(date +%Y%m%d_
2023-07-10 09:03
134
0
0
0
SELECT stu_no FROM student_course WHERE course_no IN (SELECT course_no FROM student_course WHERE stu_no='01') AND stu_no != '01';
2023-07-10 09:02
136
0
0
0
SELECT student_num,student_name FROM student_score WHERE course_score
2023-07-10 09:02
137
0
0
0
SELECT SUM(score)
FROM course
WHERE course_no = '02';