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

禁用ONLY_FULL_GROUP_BY
最新推荐文章于 2023-08-01 15:43:00 发布
原创 最新推荐文章于 2023-08-01 15:43:00 发布 · 468 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #数据库

本文介绍了一种在 MySQL 中禁用 ONLY_FULL_GROUP_BY 模式的简单方法，通过执行特定 SQL 语句来修改全局 sql_mode 设置。

进入到mysql界面；输入以下代码：
在这里插入图片描述

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
火红_
关注
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 3066
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'easy-admin.students.age' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
最新发布
DN金猿的博客
06-28 1316
经过查询资料发现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---之严格模式详解
weixin_45932995的博客
12-07 1107
严格模式参数详解： sql_mode ONLY_FULL_GROUP_BY 对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么这个SQL是不合法的，因为列不在GROUP BY从句中。简而言之，就是SELECT后面接的列必须被GROUP BY后面接的列所包含。如： select a,b from table group by a,b,c; (正确) se...
记 doris - 开发问题与解决系列
a123147abc的博客
08-26 7975
doris - 开发问题与解决系列
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
MissWwg的博客
08-30 1万+
SQL92及更早版本不允许选择列表，HAVING条件或ORDER BY列表引用在GROUP BY子句中未命名的非分组列的查询。例如，在标准SQL92中，此查询是非法的，因为name选择列表中的未列出的列不会显示在GROUP BY： SELECT o.custid, c.name, MAX(o.payment) FROM orders AS o, customers AS c...
解决Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
热门推荐
qq_39954916的博客
09-06 4万+
SELECT 日期,地域,活跃度,COUNT(qq号) as qq个数 FROM (SELECT a.`日期`,a.`qq号`,a.`地域`,IF(b.msg>=200,'高活跃度','低活跃度') AS 活跃度 FROM table_user AS a LEFT JOIN table_act AS b ON a.`日期` = b.ftime AND a.qq号 = b.qq WHERE a.`地域` IN ('广东','广东省'))t GROUP BY 日期,活跃度; 以上代码运行报错.
【MySQL】报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated
weixin_61428498的博客
08-01 658
1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum完美解决！！！！！
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
09-09
且该列没有被聚合函数（如`SUM`, `AVG`, `MAX`, `MIN`等）处理，MySQL会抛出`Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated`错误。这个问题在5.7版本之前并不严格检查，但在...
报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
loveliness_peri的博客
03-01 3万+
错误描述 [Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'community.tab_order_goods.goods_name' which is not functionally dependent on columns in GR...
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
qq_43227967的博客
03-30 8052
错误信息： [Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scp.m.manufacturer_id' which is not functionally dependent on columns in GROUP BY clause;...
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_41934715的博客
01-01 933
MARK 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'student.b.C_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.00200
MySQL问题：ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY
江南好
04-05 2806
问题描述：ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘commodity.a.xsjg’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by my
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rea
weixin_43798579的博客
09-28 1824
mysql报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘realname.t_act_coding1.nin_coding’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou
ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregate
hdyebd的博客
04-08 4882
在mysql 5.7初次使用group by时会出现错误,首先表信息如下:        ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘test.score...
[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
yangyongming_888的博客
03-09 8050
[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'epms.lk.item_fid' which is not functionally dependent on columns in GROUP BY clause; this is inco...
[Mysql 报错] 解决MySQL：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nona
汤圆的博客
09-30 1930
原因: MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BYSQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。（5.7.5之前，MySQL没有检测到功能依赖关系，默认情况下不启用ONLY_FULL_GROUP_BY。有关5.7.5之前的行为的说明，请参见“MySQL5.6参考手册”。） 先查询配置信息: select @@global
MySQL 报错＞ 1055 -Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c
qq_43183527的博客
06-30 1584
select * from V$NLS_PARAMETERS NLS_LANG=“SIMPLIFIED CHINESE_CHINA.ZHS16GBK” select * from V$NLS_PARAMETERS 步骤二：在环境变量中添加两条配置信息，鼠标右键我的电脑（计算机/此电脑）等图标，选择属性，选择高级系统设置，选择高级选项卡的环境变量，在系统变量里新建两条配置： 1、LANG=zh_CN.GBK（GBK是这样形式的，不同编码这里的value值需要跟着改变） 2、NLS_LANG=AMERIC
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值