1055 - Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column问题

最新推荐文章于 2024-06-28 13:40:42 发布

原创最新推荐文章于 2024-06-28 13:40:42 发布 · 479 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

本文记录了解决在MySQL 5.8中使用JOIN操作时遇到的问题，关键在于确保关联字段为主键。通过排查，发现正确设置主键关系能避免报错，提升查询效率。

今天在处理sql 的时候mysql报了这个错误，我使用的是mysql 5.8
最后经过排查发现问题。

在关联 JOIN 表的时候，需要关联字段主键id，则可以正常运行！

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Opticalproperti

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法

码农研究僧的博客

04-24

3108

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

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated 【已解决】

JavaPub

08-30

1116

然后重新运行语句，就可以正常查询了。在MySQL下输入如下语句。

参与评论您还未登录，请先登录后发表或查看评论

mysql5.7 group报错ERROR 1055 (42000): Expression #1

Marhal的博客

03-27

823

ubuntu16.04 apache2.4 php7.0 mysql5.7 $order_goods=db('order_goods')->where('orderid','in',$_orderid_arr)->group('orderid')->having('id>0')->select(); echo db('order_goods')->getL...

mysql出现Expression #9 of SELECT list is not in GROUP BY clause的问题

weixin_42579328的博客

08-12

1496

出现的问题如下： Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘vrapp1.b.sale_id’ which is not functionally dependent on colu mns in GROUP BY clause; this is i...

MySQL报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum

Ariel_欢

05-15

6930

1.问题描述：今天在写SQL语句时，需要将数据先按用户分组汇总，再按物品类型（测试数据库中字段是item_name）进行分组汇总，SQL语句中使用了group by分组函数，然后执行SQL报错：执行的SQL语句： SELECT a.user_id,a.item_name,a.item_id,a.approver_id,a.create_time,a.supposed_return_time FROM `t_approval` as a WHERE now() > a.supposed

MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法

最新发布

DN金猿的博客

06-28

1356

经过查询资料发现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，去掉即可。

ERROR 1055 (42000): Expression of SELECT list is not in GROUP BY clause

fj_changing的博客

01-10

653

mysql --version结果：mysql Ver 8.0.22-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu)) 报错的最后一句是this is incompatible with sql_mode=only_full_group_by 问题原因： ONLY_FULL_GROUP_BY的意思是：对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么这个SQL是不合法的，因为列不在GROUP BY从句中，也就是说查出.

Mysql启用only_full_group_by模式

qq_36261130的博客

09-05

4186

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘userinfo.t_long.user_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompat...

mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic

A乐神的博客

12-15

8590

mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic

MySQL报错:SELECT list is not in GROUP BY clause and contains nonaggregated column,解决ONLY_FULL_GROUP_BY

myyw001的博客

09-11

1678

3.去掉ONLY_FULL_GROUP_BY ，其他参数不变，执行即可。2.查看返回信息是否包含ONLY_FULL_GROUP_BY。1.查看.sql_mode配置。

使用Intellij IDEA开发JavaWeb项目时现“SELECT list is not in GROUP BY clause and contains nonaggre”的问题（项目总结）

REDANDBLUE_OvO的博客

12-03

604

1、问题说明当使用 Intellij IDEA 写项目时，需要操作数据库，但过程中出现了以下问题： 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 with sql_mod

MySQL错误SELECT list is not in GROUP BY clause and contains nonaggregated column解决”

Michael Hsu

12-12

2万+

MySQL报错如下： Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'shaogang.role_menu.role_menu_id' which is not functionally dependent on columns in GROUP BY clause...

mac mysql 1055_MySQL错误1055

weixin_39662611的博客

01-31

738

问题描述：在MySQL数据库下，执行SQL插入语句报错。错误信息如下：错误原因：在MySQL5.7之后，sql_mode中默认存在ONLY_FULL_GROUP_BY，SQL语句未通过ONLY_FULL_GROUP_BY语义检查所以报错。ONLY_FULL_GROUP_BY：ONLY_FULL_GROUP_BY要求select语句中查询出来的列必须是明确的(其他语句也是一样)。以SQL语句sele...

执行SQL（包含Group by）语句时：报错1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains no

进击的猪小Q

08-16

803

在执行MySQL语句（带有Group by）,报错

Mysql：1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated

08-25

引用:1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'senior_two.score.student_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 。引用:这个错误是由于 MySQL 的新版本中默认开启了ONLY_FULL_GROUP_BY模式，即在 GROUP BY 语句中的 SELECT 列表中，只能包含分组或聚合函数，不能包含其他列。而你的查询语句中出现了一个列senior_two.score.student_id，它既没有被分组也没有被聚合，因此 MySQL 报出了这个错误。。引用:如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测...。根据引用，这个错误意味着在SELECT语句中的第二个表达式不在GROUP BY子句中，并且包含了一个非聚合的列'senior_two.score.student_id'。这与sql_mode=only_full_group_by模式不兼容。根据引用，这个错误是由于MySQL的新版本中默认开启了ONLY_FULL_GROUP_BY模式。在GROUP BY语句的SELECT列表中，只能包含分组或聚合函数，不能包含其他列。而你的查询语句中出现了一个列'senior_two.score.student_id'，它既没有被分组也没有被聚合，因此MySQL报出了这个错误。如果你启用了only_full_group_by SQL模式（默认情况下是启用的），那么MySQL会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。123 #### 引用[.reference_title] - *1* *2* [1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘se](https://blog.youkuaiyun.com/m0_61615803/article/details/130076452)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] - *3* [解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains ...](https://download.youkuaiyun.com/download/weixin_38743076/13698627)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]