Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘studentsc

雨点打透心脏的1/2处 2024-03-16 13:55 53阅读 0赞

**目录**

问题：

原因：

解决：

修改配置文件：

1.找到MySQL安装目录下，找对my.ini(windows系统)或者my.cnf(linux系统)配置文件，并打开；

2.添加如下代码： （注意：代码一定要放在\[mysqld\]节点最后一行，别放错了哦！）

3.保存配置文件，重启服务器。（一定要重启MySQL服务器哦！）

查询成功：

--------------------

## 问题： ##

在navcat上创建视图后，执行：

SELECT * FROM student_info;

后出现一下错误:

Expression \#7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'studentscoremanagement.c.cname' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql\_mode=only\_full\_group\_by

## 原因： ##

> MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY\_FULL\_GROUP\_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。（5.7.5之前，MySQL没有检测到功能依赖关系，默认情况下不启用ONLY\_FULL\_GROUP\_BY。有关5.7.5之前的行为的说明，请参见“MySQL 5.6参考手册”。）

## 解决： ##

*  **一劳永逸的方法**

### 修改配置文件： ###

#### 1.找到MySQL安装目录下，找对my.ini(windows系统)或者my.cnf(linux系统)配置文件，并打开； ####

![e2b7c66fba304d69bacc3001ba906696.png][]

#### 2.添加如下代码： **（注意：代码一定要放在\[mysqld\]节点最后一行，别放错了哦！）** ####

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

如果你的版本是8.0以上的直接删除 ：ONLY\_FULL\_GROUP\_BY 即可

![c6d5d8dc54a147b9bf103908cb9fb3c7.png][]

#### 3.保存配置文件，重启服务器。（一定要重启MySQL服务器哦！） ####

（本人是在windows系统下亲测有效，linux没试）

重启步骤：

*  win+R 输入cmd
 *  然后输入： taskmgr 敲回车进入任务管理栏

![6dd05f16d70a4c1e9401a456c399c623.png][]

*   点击服务找到Mysql后右键，点击重新启动即可

![cef8f07bab584b1c8df80d3d86d36cbe.png][]

![d0caa150923f4aaa891f5e195b483034.png][]

#### 查询成功： ####

![06923d2d63444f0baee389461e493640.png][]

[e2b7c66fba304d69bacc3001ba906696.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/16/87bf70356fa245e994a92058a9efe8ab.png
[c6d5d8dc54a147b9bf103908cb9fb3c7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/16/200d77332e3d4d8c921335375bb9093a.png
[6dd05f16d70a4c1e9401a456c399c623.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/16/9cc9af2f85c1443da4d934a256fa1378.png
[cef8f07bab584b1c8df80d3d86d36cbe.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/16/7c11069a91584f5e8bd21a5877581dbe.png
[d0caa150923f4aaa891f5e195b483034.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/16/710169c5260f4118a8d1e9cf629c600d.png
[06923d2d63444f0baee389461e493640.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/16/7cd0d7744b494112950b68a493ecc418.png

Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘studentsc

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理

相关 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘studentsc

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

相关 MySQL5.7:of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.

相关 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.

相关【MySQL】Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 异常解决

相关 SQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '

相关 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.mon

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate