- 综合排序
- 最热优先
- 最新优先
griffin报错:ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum
解决方法: 将sql_mode中的 only_full_group_by 替换即可，方法缺点只能在当前页面有效，不能根本性解决。
10410编辑于 2025-12-23- 来自专栏世界第一语言是java
mysql5.7 ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
好郁闷，这句sql看着很正常，可是他就是报错，百度查资料基本都是修mysql的配置文件 SELECT item_id from tb_order_item as aa,tb_order as bb WHERE aa.order_id = bb.order_id GROUP BY aa.item_id ORDER BY bb.create_time desc 解决方法 SELECT item_id from tb_order_item as aa,tb_order as bb WHERE aa.
1.4K20发布于 2018-06-13 - 来自专栏码农笔录
mysql5.7 ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
好郁闷，这句sql看着很正常，可是他就是报错，百度查资料基本都是修mysql的配置文件 SELECT item_id from tb_order_item as aa,tb_order as bb WHERE aa.order_id = bb.order_id GROUP BY aa.item_id ORDER BY bb.create_time desc 解决方法 SELECT item_id from tb_order_item as aa,tb_order as bb WHERE aa.
57530发布于 2018-06-29 - 来自专栏IT云清
SQL---Expression #1 of ORDER BY clause 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 column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause
3.5K20发布于 2019-01-22 - 来自专栏关忆北.
Column ‘XXXX‘ in order clause is ambiguous
Column ‘create_time’ in order clause is ambiguous 原因是我多表查询，这个列两个表都有，需要指定一下哪个表的。
1.1K10编辑于 2021-12-07 - 来自专栏修己xj
解析SQLSyntaxErrorException异常：not in GROUP BY clause
——java.sql.SQLSyntaxErrorException，并深入探讨其中一个具体的错误信息：Expression #1 of SELECT list is not in GROUP BY clause 异常详情 Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause contains nonaggregated column 'cnpc.T1.id' which is not functionally dependent on columns in GROUP BY clause
1.2K30编辑于 2023-08-25 - 来自专栏C++/Linux
【解决】Unknown column ‘xxx‘ in ‘where clause‘
解决Unknown column ‘xxx‘ in ‘where clause‘ 当我在insert into table account values(5,‘田七’,12345.60)的时候，没有发生任何问题
1.1K30编辑于 2023-10-16 - 来自专栏关忆北.
SQLSyntaxErrorException: Unknown column ‘XXX‘ in ‘where clause‘
java.sql.SQLSyntaxErrorException: Unknown column 'XXX' in 'where clause' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException
1.4K20编辑于 2021-12-07 - 来自专栏关于Java学习@宁在春
Unknown column 字段名 in ‘where clause’
Unknown column 字段名 in ‘where clause’ 这个错误是我目前遇到最让人抓狂的错误。 这个错误的意思是**没有找到这个字段名。**我把代码翻来覆去的看，怎么看都是对的。
1.3K10编辑于 2022-10-31 - 来自专栏友儿
使用GROUP BY 发生错误 SELECT list is not in GROUP BY clause .......... 解决
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.w.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode
3.2K20编辑于 2022-09-11 - 来自专栏FHADMIN
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
错内容 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 原因分析 mysql 5.7默认启用ONLY_FULL_GROUP_BY
3.9K30编辑于 2022-03-09 - 来自专栏别先生
You cant specify target table xxx for update in FROM clause
GROUP BY RowGuid HAVING count( * ) > 1 ) 报错如下所示 You can't specify target table 'xxx' for update in FROM clause
1.4K20发布于 2019-06-03 - 来自专栏互联网技术分享
MySQL出现SELECT list is not in GROUP BY clause and contains nonaggre的问题
报错如下： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘ sss.month_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible
5.8K00发布于 2021-04-24 - 来自专栏PUSDN平行宇宙软件开发者网
MySQL报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colu
报错内容如下： 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 sql_mode=only_full_group_by, Time: 0.000000s 1055 - Expression #3 of SELECT list is not in GROUP BY clause nonaggregated column 'fbjs.mscc.ContactTime' which is not functionally dependent on columns in GROUP BY clause
1.4K50编辑于 2023-10-11 - 来自专栏java 微风
You can‘t specify target table ‘XXX‘ for update in FROM clause
报错如题，意思大致是：在一条 sql 语句中不能先查出来部分内容，再同时又对当前表作修改。
63820编辑于 2022-04-13 - 来自专栏工作经验
错误：You cant specify target table xxx for update in FROM clause的解决
select 和update 不能同时使用 解决方案 查询的时候增加一层中间表，就可以避免该错误。
25920编辑于 2023-07-17 - 来自专栏流柯技术学院
MySQL遇见SELECT list is not in GROUP BY clause and contains nonaggre的问题
student.s_no=result.s_no GROUP BY student.s_no > 1055 - Expression #2 of SELECT list is not in GROUP BY clause nonaggregated column 'db_ketest.student.s_name' which is not functionally dependent on columns in GROUP BY clause
3.1K30发布于 2020-08-28 - 来自专栏python前行者
mysql 1093 - You can‘t specify target table ‘a‘ for update in FROM clause
在更新这个表和数据的同时又去查询这个表数据，而查询的数据又做更新的条件，就产生了矛盾。
91420发布于 2021-10-13 - 来自专栏全栈程序员必看
db2中You can’t specify target table for update in FROM clause错误
发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/106217.html原文链接：https://javaforall.cn
44920编辑于 2022-08-05 - 来自专栏java 微风
You cant specify target table TS_AUTH_ADMIN for update in FROM clause记录
报错：You can't specify target table 'TS_AUTH_ADMIN' for update in FROM clause， 百度查到说是，不能在同一语句中先select出同一表中的某些值
33630编辑于 2022-04-13
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号