mysql8.0解决Expression #1 of SELECT list is not in GROUP BY问题

落切切

已于 2022-04-20 16:16:22 修改

阅读量437

点赞数

文章标签： mysql

于 2022-04-20 16:14:17 首次发布

本文链接：https://blog.csdn.net/tlingdx/article/details/124300249

版权

修改my.ini文件

在文件的[mysqld]下添加

#修改gourp by问题
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

修改后重启mysql就行了

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

落切切

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

DN金猿的博客

06-28

389

经过查询资料发现group by 聚合操作的时候，进行查询操作的列没有在group by 中出现，那么这个sql就是不合法的。主要原因就是设置的与sql_mode=only_full_group_by不兼容。今天在mysql5.7.x 升级到8.0.x版本的时候项目接口报错。通过查询发现mysql5.7.5及以上的版本都会依赖检测功能,也就是默认会开启only_full_group_by。8.0.x的版本不支持NO_AUTO_CREATE_USER，去掉即可。

解决MySQL报出1055-Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated类型的错误

weixin_45775973的博客

07-29

4164

在Mysql（版本为8.0.25）中进行分组查询的时候，频繁报出如下的错误：

参与评论您还未登录，请先登录后发表或查看评论

解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

09-09

主要介绍了解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated问题,需要的朋友可以参考下

mysql 8版本出现 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggreg...

qq_42851623的博客

10-28

1548

mysql 8版本出现 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggreg...

mysql8.0遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题解决

代码搬运工的博客

08-08

1528

mysql版本8.0，使用group by语句时提示Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的错误信息，经查需要修改默认的sqlmode，默认的sqlmode是ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_E.

mysql-8.0.13 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum

蜗牛哲学的博客

11-30

759

mysql 执行错误，如下sql SELECT * FROM ( SELECT * FROM ( SELECT * FROM student ORDER BY gmt_modified DESC LIMIT 9999 ) b GROUP BY s_no ) c WHERE 1 = 1 ORDER BY gmt_modified DESC 解决方式： Windows: 打开安装根目录的my.ini配置在[mysqld]加入sql=...，如下配置 [mysqld] # 数据库兼容配置 sq

MYSQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

li22356的博客

09-02

261

报错如下图：问题原因： 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参考手册”。）解决方法：在mysql配置文件中my

navicat15执行查询出现错误:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated

ahmcwt的专栏

11-24

800

SELECT c.cust_id,c.cust_name,o.order_num,o.order_date,o.cust_id,count(*) from customers c LEFT JOIN orders o on c.cust_id=o.cust_id GROUP BY c.cust_id; 本机:windows10,navicat15,mysql8.0.22 在执行上述语句查询时,因为加了另一个表的字段:o.order_num,o.order_date,o.cust_id,运行就报错,

Mac MySql8报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated

Jack_Tpy的Java学习之旅

07-28

856

报错信息： 1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fbjs.mscc.ContactTime’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0

Mysql使用group by分组,现错误ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and

街角有人祝福,巷口有人哭~

06-09

1164

报错信息: ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘advanced.dept.deptno’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou

MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic

weixin_63716356的博客

07-24

1884

MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column whic字面翻译： SELECT 列表的表达式 #1 不在 GROUP BY 子句中，并且包含非聚合列“grades.order_id” 它在功能上不依赖于 GROUP BY 子句中的列；这与 sql_mode=only_full_group_by 不兼容使用GROUP BY 语句违背了 sql_mode=only_

MySQL错误SELECT list is not in GROUP BY clause and contains nonaggregated column解决”

热门推荐

Michael Hsu

12-12

2万+

MySQL报错如下： Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'shaogang.role_menu.role_menu_id' which is not functionally dependent on columns in GROUP BY clause...

记一次MySQL8.0版本[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause报错问题

Hello_qjh的博客

04-06

842

mysql版本是8.0.012 升级后发现写个简单的group by语句都报错 sql:select * from table名 group by sex; 报错信息： of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fenxiangniu.stu.stuno’ which is not functionally dependent on columns in GROUP BY clause; this

mysql8.0以上执行sql[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法

luomo0203的博客

12-23

389

安装包安装解决修改配置文件 my.ini,在【mysqld] 下面增加代码： sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’ docker安装mysql解决方法解决方法 docker exec -it 容器id/容器名 /bin/bash 修改/etc/mysql/my.cnf文件添加sql_mode=‘STRICT_TR

mysql8.0报错模块配置SELECT list is not in GROUP BY clause and contains nonaggre

qq_39656564的博客

08-26

467

mysql8.0报错模块配置SELECT list is not in GROUP BY clause and contains nonaggre

关于mysql Expression #1的解决方案

flyestcoder的博客

12-21

2348

完美解决重装了mysql之后，前台页面获取后台数据老是失败，出现的错误如下 Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_s...

解决Mysql分组查询语句Expression #1 of SELECT list is not in GROUP BY clause ... ... 替换方案

码农的艺术

07-27

484

解决Mysql分组查询语句Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

达梦数据库，第二章：报错不是 GROUP BY 表达式

weixin_44519496的博客

10-12

1086

达梦数据库：在select中存在的字段，必须包含在group by 语句中 sql改造： GROUP BY R.APP_CODE,R.APP_NAME 改成：更多请见：http://www.mark-to-win.com/tutorial/51316.html

关于mysql #1 of SELECT list is not in GROUP BY clause and contains 的问题

sinat_37883343的博客

09-17

846

今天帮老师修改数据库的一些数据，发现同一条语句在服务器上的数据库中可以执行，但是在我自己电脑的数据库就不可以。错误提示为： #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '******' which is not functionally dependent on columns i...

Expression #1 of SELECT list is not in GROUP BY