navicat15执行查询出现错误:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated

最新推荐文章于 2023-11-08 15:55:26 发布
最新推荐文章于 2023-11-08 15:55:26 发布
阅读量799 收藏
点赞数
分类专栏： 数据分析 mysql 文章标签： mysql navicat
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ahmcwt/article/details/110099392
版权
在使用Navicat15与MySQL8.0.22配合时，执行带有GROUP BY的查询语句出现'Expression #3 of SELECT list...'错误，原因是sql_mode设置了ONLY_FULL_GROUP_BY。解决方法是通过调整sql_mode，去掉ONLY_FULL_GROUP_BY。然而，这仅解决了运行问题，对于需要同时展示订单数量和明细的应用场景，还需要进一步优化查询策略。
摘要由CSDN通过智能技术生成

SELECT c.cust_id,c.cust_name,o.order_num,o.order_date,o.cust_id,count(*)

from customers c LEFT JOIN orders o

on c.cust_id=o.cust_id

GROUP BY c.cust_id;

本机:windows10,navicat15,mysql8.0.22

在执行上述语句查询时,因为加了另一个表的字段:o.order_num,o.order_date,o.cust_id,运行就报错,如下：

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated c

最低0.47元/天 解锁文章
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1304
mysql中的sql__@@mode问题， 导致sql无法运行 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c.countFangWenCiShuByToday' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only
牛客高级项目（二）-MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains
小茜的博客
12-03 527
一、MySQL报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tt.from_id’ which is not functionally dependent on columns in GROU
MySQL报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
qq_34957299的博客
08-31 545
产生原因说是，在MySQL数据库版本为5.7以上的版本，默认开启了 ONLY_FULL_GROUP_BY SQL模式，在此模式下，对于group by操作,如果在select语句中的查询列没有在group by中出现，那么这个SQL就是非法的，因为列不在group by语句中，所以设置了sql_mode=only_full_group_by的数据库，在使用group by时就会报错。除了上面的手动设置sql_mode值之外，还可以在 MySQL 的配置文件中进行设置。今天在进行数据迁移时，使用。
运行报错Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column xx....
爱码士的博客
02-01 1574
安装了mysql5.7，用group by 查询时抛出如下异常： 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 ...
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column
天不拘兮地不羁
07-08 5406
“Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘workflow.s.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with s...
MySQL报错1055- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
Ariel_欢
05-15 6494
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
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column……报错的解决办法
weixin_65549694的博客
06-20 1787
问题原因：这个报错是执行有GROUP BY的语句时出现的,原因是MySQL启用了默认的only_full_group_by SQL模式,导致GROUP BY语句报错.解决办法：打开mysql的安装目录找到my.ini配置文件，添加下面这行代码： 具体位置如下：然后，右击此电脑-->管理->服务->找到mysql服务，重启此服务，问题解决。...
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
错误提示 "[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column…” 指的是在执行包含`GROUP BY`子句的查询时，你试图对未在`GROUP BY`子句中出现的列...
解决 idea报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
weixin_43864927的博客
01-09 903
idea报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 写了一个查询语句执行的时候，idea日志报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 在Navicat中执行也会报这个...
Mysql使用group by分组,现错误ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and
街角有人祝福,巷口有人哭~
06-09 1164
报错信息: ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘advanced.dept.deptno’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_grou
异常Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解决方法
最新发布
weixin_46715521的博客
11-08 389
mysql语句执行报错的解决方法
mysql5.7以上报错：Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
hhq850741642的博客
09-29 803
在写sql时报错信息：1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘pms.ru.role_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byselect @@glo
MySQL报错1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated colu
热门推荐
JaneYork的博客
02-17 1万+
1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fbjs.mscc.ContactTime' which is not functionally dependent on columns in GROUP BY clause; this is incom...
mysql:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_23157491的博客
02-24 597
解决方法：set @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
二十一克阳光！的博客
12-05 1013
在mysql中使用 group by 出现的问题 ERROR 1055 (42000): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘ynn.goods.goods_id’ which is not functionally dependent on column...
mysql报错115_mysql报错Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated ...
weixin_32340873的博客
01-30 894
今天sql一对多关联查询发现一个错误，提示说查询的字段不在group by的子句中，因为sql_mode是only_full_group_by。报错信息：#1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xt_sc.t_comment.content' ...
navicat 出现TNS:listener does not currently know of SID given in connect descriptor
08-24
这个错误通常是因为在连接字符串中指定的SID在监听器中未被识别。SID是用于标识Oracle数据库实例的唯一名称。 要解决这个问题，你可以尝试以下几个步骤： 1. 确保你的连接字符串中使用的SID是正确的。可以在数据库服务器上执行以下命令来获取正确的SID列表： ``` $ lsnrctl status ``` 然后在连接字符串中使用正确的SID。 2. 如果你确定SID是正确的，但仍然无法连接，请检查监听器配置文件（listener.ora）。确认其中包含了正确的SID。配置文件通常位于ORACLE_HOME/network/admin目录下。 3. 检查监听器是否正在运行。可以使用以下命令检查监听器状态： ``` $ lsnrctl status ``` 如果监听器未运行，可以使用以下命令启动监听器： ``` $ lsnrctl start ``` 4. 如果以上步骤都没有解决问题，可能是由于网络连接问题导致无法连接到数据库。请确保网络连接正常并且能够到达数据库服务器。 希望这些步骤能帮助你解决问题！如果还有其他疑问，请随时提问。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值