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
121
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
124
0
0
0
SELECT * FROM student WHERE score
2023-07-11 10:43
122
0
0
0
centos定时备份mysql数据库并删除过期的（自己设定）备份
新建 mysql_autobackup.sh脚本，内容如下
```
#!/bin/bash
/usr/bin/mysqldump -uus
2023-07-11 10:43
136
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
133
0
0
0
SELECT student_num,student_name FROM student_score WHERE course_score
2023-07-10 09:02
133
0
0
0
SELECT stu_no,stu_name FROM student
WHERE stu_no IN (SELECT stu_no FROM course_stu WHERE course_no = 01 I
2023-07-10 09:02
114
0
0
0