Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘cable.inve

最新推荐文章于 2024-03-27 20:42:30 发布
原创 最新推荐文章于 2024-03-27 20:42:30 发布 · 241 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
标签
#mysql #数据库 #ubuntu
本文分享了如何在遇到Mysql分类查询时遇到1055错误，通过编辑mysql.cnf文件调整sql_mode设置，解决非聚合列问题。包括修改步骤和参考链接。

今儿在分类查询时Mysql报错，

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cable.inventory.project_no' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

百度找到解决办法，在此记录一下，方便下次寻找

解决方法：

1.sudo vim /etc/mysql/conf.d/mysql.cnf

2.在配置文件最后一行粘贴以下语句

[mysqld]

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

3.保存退出后

sudo service mysql restart to restart MySQL

参考地址 解决Mysql在分类查询时报1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre... - 简书 (jianshu.com)

p7477
关注
mysql遇见Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre问题解决
axiaobaoa的博客
01-06 1万+
解决执行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
mysql Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
Orient的博客
10-21 1万+
一，问题现象 在mysql中，用group by 分组时 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre，运行的sql select a.id, a.name, a.age from a group by id, name 这个主要是违背了mysql开启的校验only_full_group_by 检测 二，问题的本质 这个问题主要是mysql 开启了onl...
mysql出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre错误
weixin_45032599的博客
01-13 8723
1、问题原因 mysql为5.7之前，则会默认启用ONLY_FULL_GROUP_BY SQL模式，MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。 2、解决方法 1、第三方视图工具（Navicat） select @@global.sql_mode 使用sql查询出结果后，一般情况会出现ONLY_FUL...
SQL 错误 [1055] [42000]: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggreg
quanqxj的博客
01-15 7622
在使用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...
mysql遇见Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
Hi_alan的博客
07-19 1万+
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; this is incompatible with sql_mode=only_full_group_by 查阅资料发现，对于group by聚合操作,如果在select中的列没
MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理
Yeats_Liao的博客
04-23 3562
MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理
MySQL报错 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column解决方法
m0_67882861的博客
11-07 6282
因为sno属性是主码，即primary key，经测试发现group by **，**为主码的属性名时，select语句中的查询列没有在group by中出现，也是允许的。红色部分可以发现sc.sno与studen.sno都没有在GROUP BY的列中，但执行语句依旧正常，因为使用了聚集函数。执行mysql语句，select 选择的列不仅仅只有sno，为什么正常输出？存书（书号，书名，出版社，版次，出版日期，作者，书价，进价，数量）现有两表Student表以及SC表(选课表)。student表结构。
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.emplo
weixin_43256057的博客
12-20 710
情况：输入以下命令 select group_concat(name),salary from employee left join department on employee.departmentID=department.d_id group by department.d_id; mysql里一旦报这个错：select group_concat(name),salary from empl...
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_36627328的博客
04-16 860
原因 出现此问题的原因是 MySQL 5.7.5 之后默认开启了 ONLY_FULL_GROUP_BY sql_mode。对此官方的解释：MySQL 实现了 函数依赖性 的检测。如果启用了 ONLY_FULL_GROUP_BY SQL模式（默认情况下是这样），MySQL 将拒绝 select list、HAVING condition 或 ORDER BY list 引用的未聚合列，这些列既不在 GROUP BY 子句中命名，也不在功能上依赖于它们。 解决方法 当然，最好的解决方法当然是修改优化 sql 语
报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
Ai_Answer_zr的博客
01-02 1121
2023-4-26：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
mysql分组时出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
Smilelfq的专栏
01-28 928
报错： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wlhy.c.com mysql分组时出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre 在mysql里面执行命令 SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONL
MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
weixin_60267414的博客
04-15 648
msql
mysql group by 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated c
wuxiaopengnihao1的博客
09-05 4263
这是MySQL8.0默认开启only_full_group_by模式导致的，该模式限定select后面跟的列，在group by后面必须要有。好了， 以上是本文所有内容，希望对大家有所帮助，也希望大家对。多多支持，你们的支持是我创作的动力！：该方式重启mysql会失效。修改配置文件my.cnf。重启mysql即可。
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘learn_mysq
Chrisliuluo的博客
03-27 776
报错原因：mysql的5.7以上版本都默认sql_mode=only_full_group_by，这个规则实际是为了提升查询的性能，因此规定我们在查询的时候只能准确的查找要查的唯一数据，不支持group by的分组条件与select的条件不一致。只能写 select id from tableA group id having id='*6*';这种语句，可以在having中控制模糊匹配，但是查询条件和分组条件必须一致。永久性解决该问题，只需要修改mysql的配置文件，my.cnf文件，添加一行配置。
解决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使用GROUP BY分组时报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
weixin_43136158的博客
08-02 1409
原因 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之前的行为的说明，请参见“MySQL5.6参考手册”。） 解决办法 在Navicat for mysql软件的Mysql命
lly dependent on columns in GROUP BY clause； this is incompatible with sql_m
有勇气的牛排博客
01-11 527
报错 ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘jol.solution.nick’ 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
梦里看花
11-22 1991
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;
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值