多列group by报错SELECT list is not in GROUP BY clause and contains nonaggregated column ‘pay_data.pay_or

最新推荐文章于 2024-06-20 09:59:06 发布
最新推荐文章于 2024-06-20 09:59:06 发布
阅读量141 收藏
点赞数
文章标签： sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43993373/article/details/120709102
版权

SQL模式 GROUP BY any_value 数据一致性 配置修改
关键词由CSDN通过智能技术生成 
执行下面语句暂时性修改sql_mode

SELECT @@sql_mode;
SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

再执行group by语句即可

或者报错的对冲突字段加上any_value(）

select giftname,any_value(time),any_value(exchangegold),any_value(start_time),any_value(end_time) from usergiftbag group by giftname

或者在/etc/my.cnf，在文件的最后加上

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
KID星心
关注
NL2SQL进阶系列(5)：论文解读业界前沿方案（DIN-SQL、C3-SQL、DAIL-SQL、SQL-PaLM）、新一代数据集BIRD-SQL解读
丨汀、的博客
04-15 1330
NL2SQL进阶系列(5)：论文解读业界前沿方案（DIN-SQL、C3-SQL、DAIL-SQL）、新一代数据集BIRD-SQL解读
Oracle Applications Multiple Organizations Access Control for Custom Code
淡
11-06 5845
文档 ID 420787.1 White Paper Oracle Applications Multiple Organizations Access Control for Custom Code Checked for relevance on 12-JAN-2011 See Change Record This document discusses how to
SELECT list is not in GROUP BY clause and contains nonaggregated column
qq_42334297的博客
09-10 8623
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使用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
mysql中SELECT list is not in GROUP BY clause and contains nonaggregated column解决办法
weixin_45810161的博客
01-02 2476
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
Mac 数据库导入新的sql文件时，如果时间是空，会报错，导入会失败
weixin_39728460的博客
11-11 377
针对mac端，并且没有my-default.cnf的用户 修改期间必须关闭mysql 我们要在/etc下新建my.cnf $ cd /etc $ sudo vim my.cnf my.cnf文件如下 # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/serv...
微软内部资料-SQL性能优化5
11-27
Each index row in node pages contains an index key (or set of keys for a composite index) and a pointer to a page at the next level for which the first key value is the same as the key value in the ...
Oracle10gOCP043题库91140题共185题
塞尔达的传说
04-16 221
原 Oracle 10g OCP 043 题库 91-140题 共185题https://blog.csdn.net/tianlesoftware/article/details/5787412版权声明： https://blog.csdn.net/tianlesoftware/article/details/5787412 91. Consider the following comma...
RAC: Frequently Asked Questions [ID 220970.1]
11-22 1204
RAC: Frequently Asked Questions [ID 220970.1]Applies to: Oracle Server - Enterprise Edition - Version 9....
mysql SELECT list is not in GROUP BY clause and contains nonaggregated column
opfan的博客
11-05 706
安装了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 i...
MySQL关于"SELECT list is not in GROUP BY clause and contains nonaggregated column"错误
weixin_42669785的博客
04-12 1823
问题 今天在写sql的时候偶然发现这个错误： select * from user group by sex; org.springframework.jdbc.BadSqlGrammarException: ###Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExceptio...
MySQL：SELECT list is not in GROUP BY clause 报错 解决方案
最新发布
换条路吧，编程没意思的~
06-20 2797
MySQL 报错：SELECT list is not in GROUP BY clause and contains nonaggregated column 解决方案
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column的解决办法
道亦无名
08-04 2500
一般安装路径在C:/ProgramData/MySQL/MySQL Server x.x下面有个my.ini配置文件。这种主要是原因是在进行数据库版本升级，但是你的sql语句没有进行改动导致的。使用记事本或者其他的编辑器打开文件，搜索“sql-mode =…2、找到data的存储路径，我这边以windows为例。一般不修改代码，修改数据库配置文件就可以解决。一般就是把第一配置去掉就可以了。1、找到mysql数据的安装路径。
SELECT list is not in GROUP BY clause and contains nonaggregated colum ..sql_mode=only_full_group_by
qq_41187577的博客
11-19 974
在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
如果SELECT语句中出现了不明确的列，就会报错"SELECT list is not in GROUP BY clause and contains nonaggregated column"。\[1\]\[2\]\[3\] #### 引用[.reference_title] - *1* [mysql使用group by查询报错SELECT ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值