解决mysql出现的问题#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated c...

最新推荐文章于 2024-06-03 10:30:40 发布
最新推荐文章于 2024-06-03 10:30:40 发布
阅读量242 收藏
点赞数
文章标签： 数据库 python
原文链接：http://www.cnblogs.com/yang-xiansen/p/9127518.html
版权

最近在学flask, 在访问主页时，一直出现1055错误，在网上找的解决方法是删除ONLY_FULL_GROUP_BY，当时是删除了，但是退出在进行select @@sql_mode时，仍出现ONLY_FULL_GROUP_BY

以下是我的解决方案：

在数据库控制台输入命令：SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

完美解决我的问题了

转载于:https://www.cnblogs.com/yang-xiansen/p/9127518.html

weixin_30254435
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
12-14
在MySQL中，错误提示 "[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column…” 指的是在执行包含`GROUP BY`子句的查询时，你试图对未在`GROUP BY`子句中...
mysql 报错解决思考Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column
zhangsir的博客
11-24 1万+
mysql报错： [Err] 1055 - Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘库名.表名.字段’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 分析 发生这个错误，一般是
1055 - Expression #4 of SELECT list is not in GROUP BY clause and contai sql_mode=only_full_group_by
Activiti工作流
12-31 2493
mysql分组查询出现下面错误 1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pfbuild.building_management.entrytime' which is not functionally dependent on columns i...
解决Mysql:1055SELECT list is not in GROUP BY clause and contains nonaggregated
最新发布
weixin_43683432的博客
06-03 319
具体来说，当MySQL的sql_mode设置为only_full_group_by时，它要求SELECT列表中的非聚合列必顋在GROUP BY子句中，或者是函数依赖于GROUP BY子句中的列。换句话说，如果在GROUP BY子句中指定了某些列进行分组，那么SELECT列表中的非聚合列必须与GROUP BY子句中的列相关联。这个错误提示是因为在使用了GROUP BY子句的情况下，SELECT列表中的非聚合列（没有使用聚合函数进行处理的列）必须出现在GROUP BY子句中。
#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i
Flyer的后花园
07-14 1808
这个sql语句违背了sql_mode=only_full_group_by 。 先看看这个sql_mode=only_full_group_by是个什么意思: (摘自官网文档) 1 2 3 4 5 ONLY_FULL_GROUP_BY Reject queries for which the select l
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 1237
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 #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘h
爱驹一族的博客
06-14 1453
完整报错 原因： MySQL 5.7.5和up实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测到功能依赖项，only_full_group_by在默认情况下是不启用的。关于前5.7.5行为的描述，请参阅MySQL 5.6参考手册。) 聚合列的方式 将报错的字段用MAX（）函数括起来（注意空格
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
12-15
如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于它们。(在5.7.5之前，MySQL没有检测...
mysql遇到Expression.docx
03-05
在MySQL中，当你尝试执行一个包含`GROUP BY`子句的查询时，可能会遇到"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"这样的错误。这个错误提示表明你的查询违反了`...
解决MySQL 5.7.9版本sql_mode=only_full_group_by问题
12-16
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘col_user_6.a.START_TIME’ which is not functionally dependent on columns in GROUP BY clause; this is ...
[Err] 1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated colum
热门推荐
hhczy1003的专栏
08-23 1万+
这个错误发生在mysql 5.7.5 和以后上，因为5.7.5默认的sql模式配置是 ONLY_FULL_GROUP_BY，  这个配置启用的是 “严格ANSIsql 规则”，严格ANSI sql 规则要求在group by的时候，没有聚合的列，在group by的时候，必须全部包含在group by 的字段中。 没有聚合的列，指的是没有使用 max, min, count,
Mysql报错解决 1055. Expression #5 of SELECT list is not in GROUP BY... 1067:Invalid default value for...
qq_38828872的博客
04-12 350
mysql报错：[Error Code: 1055. Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx' which is...];[Error 1067: Invalid default value for...]
group by产生错误#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
weixin_44090680的博客
06-27 666
Mysql5.7版本以上对group by 分组有了新需求，要求group by 后的字段要与select后查询的字段一致，否则就会报错。
[Linux 完美解决]Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column
m0_48296376的博客
03-24 2114
错误 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
MYSQL---之严格模式详解
weixin_45932995的博客
12-07 809
严格模式参数详解： sql_mode ONLY_FULL_GROUP_BY 对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么这个SQL是不合法的，因为列不在GROUP BY从句中。简而言之，就是SELECT后面接的列必须被GROUP BY后面接的列所包含。如： select a,b from table group by a,b,c; (正确) se...
Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
李利科
02-01 3491
执行以下sql报错： SELECT name,sex,location FROM tp_music.singer group by sex; 报错信息： Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tp_music.singer.name’ which is not functionally dependent on columns i
1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated clause and con
别浪
01-19 689
在数据库控制台输入命令： SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));  
解决MySQL报出1055-Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated类型的错误
weixin_45775973的博客
07-29 4124
在Mysql（版本为8.0.25）中进行分组查询的时候，频繁报出如下的错误：
解决mysql出现的问题#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i
10-14
解决此问题的方法是将SELECT列表中的所有列都包含在GROUP BY子句中，或者将未包含在GROUP BY子句中的列用聚合函数进行处理。 例如，假设我们有一个名为orders的表，其中包含订单号、客户ID和订单总金额。我们想按...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值