mysql 查詢 SELECT list is not in GROUP BY clause and contains nonaggregated column

最新推荐文章于 2024-06-20 09:59:06 发布
最新推荐文章于 2024-06-20 09:59:06 发布
阅读量107 收藏
点赞数
分类专栏： mysql 文章标签： mysql
原文链接：https://www.cnblogs.com/chcha1/p/12996860.html
版权

一、第一种方法

在navicat 执行以下sql 
set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO';

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO'

set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO';


set @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO';
 

转载自：https://www.cnblogs.com/chcha1/p/12996860.html

人生海海-hai
关注
专栏目录
mysql报错：Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
DN金猿的博客
06-28 389
经过查询资料发现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，去掉即可。
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘c.countFan
weixin_43802097的博客
05-12 1305
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 8.0.21 “SELECT list is not in GROUP BY clause and contains nonaggregated column...“错误解决方案
TuTuTu_Tu的博客
09-21 871
今天用EF框架生成Mysql实体模型时遇到了 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘STATISTICS.INDEX_TYPE’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql中SELECT list is not in GROUP BY clause and contains nonaggregated column解决办法
weixin_45810161的博客
01-02 2705
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 whic
A乐神的博客
12-15 8045
mysql 提示SELECT list is not in GROUP BY clause and contains nonaggregated column whic
MySQL：SELECT list is not in GROUP BY clause 报错 解决方案
最新发布
换条路吧，编程没意思的~
06-20 4024
MySQL 报错：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...
weixin_43702272的博客
12-20 1387
项目在windows上运行正常，迁移到Linux系统上就出现了这个错，经查是由于本人sql不规范且恰好mysql的sql_mode启用了only_full_group_by，当sql语句中使用了分组查询，并且查询的字段不在group by子句中就会出现这个报错提示。 报错详情：(sql版本8.0.13) SELECT list is not in GROUP BY clause and con...
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
weixin_40925480的博客
11-03 1145
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...
weixin_43697366的博客
06-08 647
今天接口突然返回这个错误： 因为一直使用的是阿里云 rds实例，之前接口返回正常，没有更新过代码，因为最近重新购买了该实例rds,所以问题定位到这个上边，后来查询是mysql的配置是默认了参数的sql_mode=only_full_group_by MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错 通过该命令查询：SELECT @@sql_mode 解决方法就是在对应rds实例化的.
[Linux 完美解决]Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column
m0_48296376的博客
03-24 2171
错误 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
【解决】 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 8.0下的SELECT list is not in GROUP BY clause and contains nonaggregated column
aituochang1886的博客
08-27 1091
mysql的版本 mysql> select version();+-----------+| version() |+-----------+| 8.0.12 |+-----------+ 在执行group by时遇到报错，具体如下 mysql> select * from api_properties GROUP BY file_id order by fi...
mysql 8版本出现 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggreg...
qq_42851623的博客
10-28 1548
mysql 8版本出现 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggreg...
sql报错SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_40262372的博客
06-24 9831
高频面经汇总：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..
SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_42334297的博客
09-10 8666
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语句的问题，
MySQL： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '
MADE_Y
09-14 6631
http://www.zhimengzhe.com/shujuku/other/252133.html 今天在执行MySQL中sql语句的时候报错了，执行的sql语句： SELECT prov_desc, area_desc, month_id, MAX(total_fee)AS max_total, FROM sss WHERE pro
【已解决】SELECT list is not in GROUP BY clause and contains nonaggregated column
nanke_yh的博客
10-14 1058
一、原因 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
SELECT list is not in GROUP BY clause and contains nonaggregated colum ..sql_mode=only_full_group_by
qq_41187577的博客
11-19 992
在mysql查询语句中使用group by语句查询报如下错误: [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘mini.a.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_ful
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column
07-27
- *1* [mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.](https://blog.csdn.net/weixin_40925480/article/details/127680083)[target="_blank" data-report-...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值