Mysql Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

最新推荐文章于 2024-05-10 17:22:56 发布
最新推荐文章于 2024-05-10 17:22:56 发布
阅读量501 收藏
点赞数
分类专栏： SQL语句 文章标签： mysql 数据库 sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_47156901/article/details/108127044
版权

mysql 遇到Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

解决方法
在网友修改global.sql_mode以后还是报错的情况下可以试试下面的方法

1.检查你的SQL语句，出现这个情况一般是GROUP BY用错
2.检查你的GROUP BY 所在的SQL语句中的SELECT 后面跟的字段是否正确，一般SELECT 后面跟的是单表中的你要分组后进行计算的字段。（这边尽量只有一个你要进行计算字段）GROUP BY一般是对单表进行排序，所以不建议在多表连接的情况下使用
3.这时候如果非要用GROUP BY语句，你就不要用左连接或者又连接写，采用子查询

努力敲代码的咸鱼
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
[Linux 完美解决]Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column
m0_48296376的博客
03-24 2058
错误 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 一、 其他参考文档 临时解决方法: Mysql解决SELECT list is not in GROUP BY clause and contains nonaggregated column 问题 另一个: mysql遇见Expression #1 of SELECT list is not in GROUP BY clau
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
12-15
如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测...
mysql报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
lk的博客
01-19 7441
报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 1.描述： 数据库中的表grades为 id | gro | name | score --------------------------- 1 | A | 张三 | 20 2 | B | 李四 | 19 3 | B | 王五 ...
遇见 mysql Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 问题
Tz.的博客
07-08 4135
这是因为mysql5.7及以上版本的mysql中，对于 group by 的这种聚合操作，如果在select 中的列， 没有在group by 中出现，那么这个SQL是不合法的，因为列不在group by的从句中，所以对于设置了这个mode的数据库，在使用group by 的时候，就要用MAX()，SUM()，ANT_VALUE()的这种聚合函数，才能完成GROUP BY 的聚合操作。 查询以后发现是因为only_full_group_by设置的原因，下边我们将其进行关闭： 1. 第一种的解决办法是.
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
最新发布
iummature的博客
05-10 218
Windows操作系统中的MySQL配置文件是“my.ini”，位置一般在MySql安装的根目录下，也有可能在隐藏文件夹“ProgramData”下面；而Linux操作系统中的MySQL配置文件是“my.cnf”，位置一般在“/etc/my.cnf”或“/etc/mysql/my.cnf”目录下。查出的值，删除ONLY_FULL_GROUP_BY，或者直接使用下面sql重新设置sql_mode。找到my.cnf，修改配置文件my.cnf。但是此方法mysql重启后可能会恢复。重启mysql即可。
SQL 错误 [1055] [42000]: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggreg
quanqxj的博客
01-15 6814
在使用group by时，报错信息如下： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mome.a.type' which is not functionally dependent on columns in GROUP...
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
热门推荐
lxw1844912514的博客
09-18 4万+
报错:ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'work_ad.api_community_pic.id' which is not functionally dependent on columns in GROUP B...
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP ...
mysql遇到Expression.docx
03-05
在MySQL中，当你尝试执行一个包含`GROUP BY`子句的查询时，可能会遇到"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"这样的错误。这个错误提示表明你的查询违反了`...
MySQL使用中遇到的问题记录
12-15
#1 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by 解决办法 # 设置正确的 sql_mode 即可解决 # 登陆MySQL ...
Mysql问题Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
梦里看花
11-22 1558
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXXX' which is not functionally dependent on columns in GROUP BY clause;
mysql 8版本出现 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggreg...
qq_42851623的博客
10-28 1453
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 nonag..
qq_45721173的博客
03-29 1416
问题描述 用mybatis写sql语句的时候，用到了group by关键字，运行报错mysql8.0报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘drive.drive_data.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with
mysql 连表查询分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
weixin_42385565的博客
11-05 313
第一次写博客 记录一下把 本人菜狗一个 对于链表查询 我这边是报一个分组错误 百度了很久 基本都是让修改mysql的校验 要不就是使用mysql5.7以下的版本， 所以直接就关闭了 ，找了一个前辈说自己的sql有问题 但是sql客户端能执行 后台调用接口就会报错 贴个sql 容易 指出问题 在后台执行就会报 分组问题 后来前辈说连表查询的时候的对没有聚合函数的字段也得放到分组后面然后就改成这样了就可以运行了 以前用的是mysql5.5的语法没有检测机制 一直以为自己写的没问题 记录一下。 ..
mysql遇见Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre问题解决
axiaobaoa的博客
01-06 9862
解决执行sql语句报错Expression #2 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
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
weixin_45626288的博客
03-29 3006
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wsq.m.chat_room_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cre
weixin_43085797的博客
04-14 9973
sql语句 SELECT * FROM t_company_change_log WHERE company_id='257949626441666560' AND rec_status='N' GROUP BY change_item 这样会在某些版本的数据库中运行出错 原因是 5.7.5之后版本默认启用了only_full_group_by SQL模式，所以MySQL会不识别选择列表...
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate...
我是jjking`
09-09 616
执行sql语句报错： ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.fruits.f_id' which is not functionally dependent on columns in GROUP BY c...
MySQL遇见Expression this is incompatible with sql_mode=only_full_group_by
流风雨情的博客
11-20 226
当在查这个sql的时候 SELECT a.*, count(b.id) FROM stu a LEFT JOIN stu b ON a.class = b.class AND a.score < b.score GROUP BY a.id Expression #2 of SELECT list is not in GROUP BY clause and contains nona...
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
09-26
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘grades.order_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值