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 发布 · 480 阅读

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

3112

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

1118

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

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

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

Marhal的博客

03-27

824

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

1497

出现的问题如下： 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”解决方法

热门推荐

lucky多多的博客

03-22

5万+

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

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

weixin_42979574的博客

05-30

475

先新建查询，再键入set @@global.sql_mode =‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;1.先查询一下sql_mode的值（确认一下MySQL是不是真的默认给设置了mysql sql_mode = only_full_group_by 属性）果真出现了ONLY_FULL_GROUP_BY。

mysql 查询 is not in_MySQL遇见SELECT list is not in GROUP BY clause and contains nonaggre的问题...

weixin_29322855的博客

01-18

635

报错现象执行SQL报错如下：SELECT student.s_no,student.s_name,SUM(result.mark) FROM student,result WHERE student.s_no=result.s_no GROUP BY student.s_no> 1055 - Expression #2 of SELECT list is not in GROUP BY cl...

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

weixin_61428498的博客

08-01

663

1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum完美解决！！！！！

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

qq_42926722的博客

10-25

5377

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

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

最新发布

DN金猿的博客

06-28

1361

经过查询资料发现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

8594

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

740

问题描述：在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

804

在执行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;...