CentOS7默认数据库是mariadb, 但是 好多用的都是mysql ，但是CentOS7的yum源中默认好像是没有mysql的。上一篇安装的是5.6的但是我想安装5.7的 yum安装是最简单的 尝试过编译安装各
2021-12-07 14:35
174
0
0
0
SELECT stu_num, stu_name FROM student WHERE stu_num IN (SELECT stu_num FROM student WHERE stu_num != 01 IN
2023-06-20 09:33
173
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
173
0
0
0
asp连接mysql代码
asp连接mysql之前须安装aMyODB
下载地址
http://www.skycn.com/soft/2141.html
一般中文都会乱码
乱码解决方法
conn.E
2021-12-07 14:44
173
1
1
0
```
SELECT course_id, course_name,
COUNT(CASE WHEN score BETWEEN 100 AND 85 THEN 1 END) AS 100-85,
2023-07-11 10:53
172
0
0
0
SELECT
SUM(CASE WHEN sex=男 THEN 1 ELSE 0 END) AS 男生人数,
SUM(CASE WHEN sex=女 THEN 1 ELSE 0 END) AS 女生人数
F
2023-07-13 09:13
172
0
0
0
1. 查看该数据库实例下所有库大小，得到的结果是以MB为单位mysql>selecttable_schema,sum(data_length)/1024/1024asdata_length,sum(index_len
2021-12-07 14:34
172
0
0
0
SELECT sno,AVG(score)
FROM student
WHERE score < 60
GROUP BY sno
HAVING COUNT(score)>=2;
2023-07-14 09:07
171
0
0
0