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 s.name AS 姓名, c.name AS 课程名称, s.score AS 成绩, AVG(s.score) AS 平均成绩
FROM student s, course c
WHERE
2023-07-11 10:49
133
0
0
0
SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
133
0
0
0
Student(S#,Sname,Sage,Ssex) 学生表Course(C#,Cname,T#) 课程表SC(S#,C#,score) 成绩表Teacher(T#,Tname) 教师表问题：1、查询“001”课程
2021-12-07 14:35
133
1
1
0
```
SELECT
c.id,
c.name,
MAX(s.score) AS maxScore,
MIN(s.score) AS minScore,
AVG(s.score) AS avgScore,
2023-07-11 10:50
135
0
0
0
centos定时备份mysql数据库并删除过期的（自己设定）备份
新建 mysql_autobackup.sh脚本，内容如下
```
#!/bin/bash
/usr/bin/mysqldump -uus
2023-07-11 10:43
136
0
0
0
答：该错误主要是由于MySQL的sql_mode配置值设置错误导致的，可以尝试执行以下SQL语句来修复：
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,STRIC
2023-07-05 09:10
136
0
0
0