SELECT student_no,student_name,COUNT(course_no) AS course_num,SUM(score) AS total_score FROM student LEFT
2023-06-16 08:34
176
0
0
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
175
0
0
0
：
1.查看字符集：
使用SHOW VARIABLES LIKE character_set_%查看MySQL的字符集，其中%表示通配符，表示所有以character_set开头的变量。
2.修改字符集：
（
2023-06-25 17:13
175
0
0
0
SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
175
0
0
0
1. 语法选项说明-h, --host=name主机名-P[ port_num], --port=port_num用于连接MySQL服务器的的TCP/IP端口号--master-data这个选项可以把binlog的位
2021-12-07 14:33
175
0
0
0
centos使用mysqldump备份mysql数据库
```bash
#! /bin/bash
Now=$(date +%d-%m-%Y-%H:%M)
File=bk-$Now.sql
mysql
2023-06-02 12:18
175
0
0
0
select student.name, course.name, score.score
from student
inner join score on score.student_id=student.
2023-07-13 09:14
174
0
0
0