mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

最新推荐文章于 2024-04-24 08:00:00 发布

丶moli

最新推荐文章于 2024-04-24 08:00:00 发布

阅读量430

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/oRanXiaoLuo/article/details/105475277

版权

数据库专栏收录该内容

13 篇文章 0 订阅

订阅专栏

最近在做项目的时候遇见视图分组打不开，这里就不说明原因了，网上多的很，直接上解决办法：

1、首先打开mysql的配置文件，到你的安装目录去找（my.ini）
在这里插入图片描述
打开编辑

复制下面这个代码：

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

保存之后重启服务，（linux就不说了，不会的百度）

2、windows的打开我的电脑右键------管理------服务和应用程序------服务
在这里插入图片描述

3、重启，是不是就好了？

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

丶moli

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

09-09

主要介绍了解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated问题,需要的朋友可以参考下

MySQL运行报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre解决方法

热门推荐

Allen_Tsang的博客

02-06

2万+

MySQL 5.7.5后only_full_group_by成为sql_mode的默认选项之一，这可能导致一些sql语句失效。比如下表game： id group_id name score 1 A 小刚 20 2 B 小明 19 3 B 小花 17 4 C 小红 18 执行sql: select name, grou

MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法

m0_52789121的博客

06-07

1309

今天使用mysql简单的一句分组查询语句（GROUP BY）报错了。查了问题原因和解决方法，成功解决。原因：使用GROUP BY 语句违背了sql_mode=only_full_group_by。因为mysql版本5.7之后默认的模式是ONLY_FULL_GROUP_BY。官网文档的原话：说人话，大概意思就是说（使用google翻译）：1、先使用SQL查询sql_mode 2、重新设置sql_mode，删除ONLY_FULL_GROUP_BY 3、退出重进再次执行查询语句，...

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 #1 of SELECT list is not in GROUP BY clause and contains nonaggre报错

weixin_43140656的博客

11-28

700

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre …后面一大堆出错就是这样我们可以在网上看到很多解释 MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查...

出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法

码农研究僧的博客

04-24

1841

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

MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”

weixin_34321977的博客

05-15

154

原文地址：http://www.cnblogs.com/lonelywolfmoutain/p/5433581.html执行SQL:SELECTlogin_name,login_ip,sexFROMtank_adminGROUPBYlogin_name;时抛出异常。Expression#2ofSELECTlistisnotinGROUPBYc...

mysql报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

lk的博客

01-19

8777

报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 1.描述：数据库中的表grades为 id | gro | name | score --------------------------- 1 | A | 张三 | 20 2 | B | 李四 | 19 3 | B | 王五 ...

mysql：报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonag

欢迎来到 ABin-阿斌的博客：写一生代码，创一世佳话，筑一览芳华。

05-24

1168

声明：原文作者【CSDN】：lankun66 原文地址：https://blog.csdn.net/qq_44625080/article/details/104043682 前言最新在开发中遇到了一个问题，就是在代码书写中我用了 GroupBy做去重处理。在开发环境测试是好的，但是发布到测试就报了如下错误。报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre 后来问运维兄弟才知道：测试环境

mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated 的问题

keep12moving的博客

11-20

249

https://blog.csdn.net/qq_34707744/article/details/78031413

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre

09-26

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘grades.order_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible ...