Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘aa.lid‘ wh

最新推荐文章于 2024-01-02 09:46:00 发布
最新推荐文章于 2024-01-02 09:46:00 发布
阅读量97 收藏
点赞数
分类专栏： 本地环境 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_39636712/article/details/108526316
版权

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

今天使用多对多查询对字段进行了排序，出现以上错误，进过各种查询，找到解决办法，但是网上很多都是复制的别人的，试过以后首先报语法错误，
这里我直接说一下把那个引号自己改一下就解决了，然后又会报错，ERROR 1231 (42000): Variable ‘sql_mode’ can’t be set to the value of ‘NO_AUTO_CREATE_USER’
这个问题把这删掉就可以，然后执行sql发现还是报错。我懵逼了，头疼的很，解决不了一度想重新安装，打了会游戏缓解一下烦躁的心情，继续查，终于在一篇文章中找到正确解决方案，这里我不说什么my,conf什么的解决方案了，直接一点能解决的。
命令行进入mysql：mysql -u root -p
然后直接复制输入set SESSION sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION ';
回车，再执行sql，解决。如果有人想了解更清楚，我把看到的这篇链接发出来，有兴趣的朋友可以去仔细看看，还是很有用的。
https://blog.csdn.net/weixin_40277684/article/details/102952129?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase

码上爱
关注
专栏目录
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 230
经过查询资料发现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，去掉即可。
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
最新发布
码农研究僧的博客
04-24 1419
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
SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_42334297的博客
09-10 8620
SELECT list is not in GROUP BY clause and contains nonaggregated column问题解决方案单次解决修改配置文件使用规范的sql语句 问题 在单独部署项目的时候遇到了这个问题，具体意思就是： SELECT列表不在GROUP BY子句中，且包含非聚合列 意思应该就是SELECT的属性必须出现在GROUP BY语句中，即类似于SELECT a.name FROM user a GROUP BY a.name这种样子。 问题根源应该是sql语句的问题，
【解决】 SELECT list is not in GROUP BY clause and contains nonaggregated column
丑小鸭
01-18 1万+
出错情况 问题分析 出现此异常的原因是：如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用在GROUP BY子句中既未命名的非集合列，也不在功能上依赖于它们。 使用数据库的版本信息 mysql-8.0.15-winx64 解决策略 法 1 1 查看 sql_mode 1 使用以下命令查看自己的 sql_mode select @@global.sql_mode; 或者 show variables
MySQL中Group By遇到 SELECT list is not in GROUP BY clause and contains nonaggregated ........
xiaoxu9522的博客
07-09 1009
遇见的报错具体是这样的： Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a .time2' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 大概的意思就是：select 语句中的
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
A乐神的博客
12-15 7625
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
sql报错SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_40262372的博客
06-24 9796
高频面经汇总：https://blog.csdn.net/qq_40262372/article/details/116075528 一、问题分析 其中错误的原因是说group by哪一句中的select的字段是不对的。 二、情景还原 dept_emp表： salaries表： 我想去查询每个部门人员薪水，于是写下了这样的sql: select de.dept_no ,s.salary from dept_emp de left join salaries s on..
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1272
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
[Linux 完美解决]Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column
m0_48296376的博客
03-24 2136
错误 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 一、 其他参考文档 临时解决方法: Mysql解决SELECT list is not in GROUP BY clause and contains nonaggregated column 问题 另一个: mysql遇见Expression #1 of SELECT list is not in GROUP BY clau
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_36627328的博客
04-16 508
原因 出现此问题的原因是 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 语
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...解决方案
study_in的博客
06-19 7万+
MySQL5.7.5后only_full_group_by成为sql_mode的默认选项之一，这可能导致一些sql语句失效。 比如在使用group by进行分组查询报错 1 查看自己的sql_mode配置: 在sql命令行中输入select @@sql_mode;这时我们能够看到自己的sql_mode配置,其中如果有ONLY_FULL_GROUP_BY,那它就是group by查询报错的罪魁祸...
SELECT list is not in GROUP BY clause and contains nonaggregated column解决和总结
ITxiaofeixiang的博客
04-12 4万+
问题描述 查询语句 SELECT name,sum(class_id) from res GROUP BY class_id 结果 SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dt.res.name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=o
【已解决】SELECT list is not in GROUP BY clause and contains nonaggregated column
nanke_yh的博客
10-14 1046
一、原因 MySQL5.7.5后only_full_group_by成为sql_mode的默认选项之一，这可能导致一些sql语句失效。 二、解决办法 1、命令行打开mysql.cnf,默认路径为/etc/mysql/conf.d/mysql.cnf,如果找不到可以使用whereis进行查询 sudo vim /etc/mysql/conf.d/mysql.cnf 按i 进行编辑 2、滚动到文件底部复制并粘贴以下代码 [mysqld] sql_mode = STRICT_TRANS_TABL
mysql中SELECT list is not in GROUP BY clause and contains nonaggregated column解决办法
weixin_45810161的博客
01-02 2432
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
解决MySql下SELECT list is not in GROUP BY clause and contains nonaggregated column (ONLY_FULL_GROUP_BY)
MrYang_Wei
05-18 838
一、问题描述 今天同事遇到了一个数据库问题，在此我来进行记录。我们先看下sql片段 分析下这段sql，我们在使用 group by 关键字进行查询时，select 下检索列理应只包含group by 下的字段及聚合函数，但奈何场景需要，有时又想加上其它字段，而且她这样写在本地是可以运行的！！！ 二、解决方案 首先，本地的MySQL数据库版本是5.5.x，而linux服务器下的数据库版本为5.7.x。其次，在本地执行这段sql是没有问题的，而在服务器上才会出现这个问题。显而易见，这是由于MySQL
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...原因及解决方案
江海寄余生的博客
03-30 1万+
最近公司新建了一个项目，在项目中需要用到group by进行聚合计算，在计算的同时也要查出一些其他字段来返回给前端。于是就有了这个错误的出现。 先简单复现我所写的sql，其实sql非常简单。 select channel_name as channelName, brand_name as brandName, sum(actual_value) as actualValue, sum(actual_value_ty) a
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.
热门推荐
fansili的博客
11-29 8万+
安装了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 GR
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...
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
07-29
引用\[1\]、\[2\]和\[3\]都是关于MySQL报错的信息，其中提到了"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"的错误。这个错误是由于在使用GROUP BY子句进行分组查询...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值