SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
149
0
0
0
mysql>showglobalstatuslikeuptime;
+---------------+--------+
|Variable_name|Value|
+---------------+--------
2021-12-07 14:35
149
0
0
0
SELECT sno,AVG(score)
FROM student
WHERE score < 60
GROUP BY sno
HAVING COUNT(score)>=2;
2023-07-14 09:07
151
0
0
0
答：该错误主要是由于MySQL的sql_mode配置值设置错误导致的，可以尝试执行以下SQL语句来修复：
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,STRIC
2023-07-05 09:10
151
0
0
0
CentOS7默认数据库是mariadb, 但是 好多用的都是mysql ，但是CentOS7的yum源中默认好像是没有mysql的。上一篇安装的是5.6的但是我想安装5.7的 yum安装是最简单的 尝试过编译安装各
2021-12-07 14:35
152
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
152
0
0
0
SELECT student_num,student_name FROM student_score WHERE course_score
2023-07-10 09:02
153
0
0
0