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

迈不过友情╰ 2022-12-29 04:56 292阅读 0赞

运行报错：

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘test.dept_emp.emp_no’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方法：

在Navicat下执行下面语句，重新打开即可成功。

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NpZWxfWQ_size_16_color_FFFFFF_t_70

原因

MySQL5.7.5及以上默认启用了ONLY_FULL_GROUP_BY
SQL模式，也就是依赖检测功能。MYSQL将拒绝选择列表，这时HAVING条件或ORDER BY查询出的数据会被认为是未命名的非集合列。

发表评论取消回复

表情：

评论列表（有 0 条评论，292人围观）

还没有评论，来说两句吧...

相关阅读

相关 MySQL Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column异常处理

目录一、异常错误二、原因三、解决方法一、异常错误使用联表查询时，group by两个字段出现了错误 ![在这里插入图片描述][311

Myth丶恋晨/ 2024年03月23日 16:22/ 0 赞/ 170 阅读

相关 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘studentsc

目录问题：原因：解决：修改配置文件： 1.找到MySQL安装目录下，找对my.ini(windows系统)或者my.cnf(linux系统)配置文件，并打开

雨点打透心脏的1/2处/ 2024年03月16日 13:55/ 0 赞/ 156 阅读

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

场景安装了mysql5.7，用group by 查询时抛出如下异常： Expression \1 of SELECT list is not in GROUP BY

女爷i/ 2023年10月18日 13:53/ 0 赞/ 233 阅读

相关 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

问题：Expression \2 of SELECT list is not in GROUP BY clause and contains nonaggregated col

淩亂°似流年/ 2023年09月30日 11:43/ 0 赞/ 41 阅读

相关 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cre

sql语句 SELECT FROM t_company_change_log WHERE company_id='257949626441666560' AND

亦凉/ 2023年07月25日 11:18/ 0 赞/ 140 阅读

相关 mysql8 Expression #16 of SELECT list is not in GROUP BY clause and contains nonaggregated column

出错 Expression 16 of SELECT list is not in GROUP BY clause and contains nonaggregat

ゝ一世哀愁。/ 2023年02月28日 12:56/ 0 赞/ 102 阅读

相关 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column

运行报错： Expression \2 of SELECT list is not in GROUP BY clause and contains nonaggregat

迈不过友情╰/ 2022年12月29日 04:56/ 0 赞/ 293 阅读

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.

安装了mysql5.7，用group by 查询时抛出如下异常： Expression 3 of SELECT list is not in GROUP BY cla

雨点打透心脏的1/2处/ 2022年06月04日 00:10/ 0 赞/ 279 阅读

相关 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.mon

问题出现的原因： MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY\_FULL\_GROUP\_BY SQL模式（默认情况下），MySQL将拒绝选择列表，

一时失言乱红尘/ 2022年03月18日 09:24/ 0 赞/ 292 阅读

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate

Expression \1 of SELECT list is not in GROUP BY clause and contains nonaggregate

野性酷女/ 2021年10月23日 19:34/ 0 赞/ 301 阅读