学习路之PHP--使用GROUP BY 发生错误 SELECT list is not in GROUP BY clause .......... 解决

原创 已于 2024-11-21 10:02:02 修改 · 337 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#学习 #php #开发语言

于 2024-11-21 09:50:20 首次发布

解决方法：

1.查询mysql 相关mode
select @@global.sql_mode;
可以看到模式中包含了ONLY_FULL_GROUP_BY，只要没有这个配置即可。
我的Mysql版本是5.7.23，默认是带了ONLY_FULL_GROUP_BY模式。
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
解决方法一：set @@global.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

解决方法2：
打开mysql配置文件：my.cnf或者my.ini，直接选择打开mysql配置文件，然后在[mysqld]下面添加    sql_mode=ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT,ANSI_QUOTES
重启mysql即可

如果是phpstudy,可参考学习路之phpstudy--安装mysql5.7后在my.ini文件中无法修改sql_mode-优快云博客

hopetomorrow
关注
出现User 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated 解决方法
码农研究僧的博客
04-24 3052
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使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
weixin_40925480的博客
11-03 1261
mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column.
thinkphp5 mysql5.7_thinkphp5+mysql5.7.20 group方法异常解决方法
weixin_30378963的博客
01-19 505
thinkphp5+mysql5.7.20 group方法异常解决方法SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'movie.tp_video_tags...
phpstudy 搭建的项目： GROUP BY clause; this is incompatible with sql mode=only-full_group_by
程序员-大雄的博客
03-27 121
问题如图： 方法一：直接修改数据库配置首先，打开数据库，输入 select @@global.sql_mode; 这个时候，就会返回得到以下的信息：(不同电脑返回的信息可能不同) ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION如果里面包含 ONLY_FULL_GROUP_BY，那么就重新设置，在数据库中输入以下代...
TP6 使用group去重时报错42000
xiaoyao086的博客
01-08 1478
报错SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tp.ip.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_m
数据库报错：SELECT list is not in GROUP BY clause
lmp5023的博客
11-18 363
mysql5.7使用group by出现错误： [Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.score.c_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_f..
thinkphp中分页paginate和group by一起使用时 代码异常的解决办法
qq_32450471的博客
08-11 584
thinkphp中分页paginate和group by一起使用时 代码异常的解决办法
MySql遇到的问题--group by报错“1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains..”
Dbao_miao的博客
03-20 1911
学习group by遇到的问题表，id为主键 表，id为主键 ±—±---------±----------±--------------------±-----------+ | id | LastName | FirstName | Address | City | ±—±---------±----------±--------------------±-----------+ | 1 | Adams | John | Oxford Street
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使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...
weixin_43697366的博客
06-08 748
今天接口突然返回这个错误： 因为一直使用的是阿里云 rds实例，之前接口返回正常，没有更新过代码，因为最近重新购买了该实例rds,所以问题定位到这个上边，后来查询是mysql的配置是默认了参数的sql_mode=only_full_group_by MySql在低版本（5.7.x以下）中允许select后面的非聚合列不出现在group by中。以下sql在低版本中是可以运行的，但是在5.7及以上版本会报错 通过该命令查询：SELECT @@sql_mode 解决方法就是在对应rds实例化的.
MySQL：SELECT list is not in GROUP BY clause 报错 解决方案
最新发布
换条路吧，编程没意思的~
06-20 6358
MySQL 报错：SELECT list is not in GROUP BY clause and contains nonaggregated column 解决方案
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
热门推荐
N-SOKACH的博客
09-19 18万+
报错如下： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.month_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompat
解决SELECT list is not in GROUP BY clause and contains nonaggregated column 'novle'
yyy2567338788的博客
01-21 2万+
使用MySQL，创建视图，SQL语句如下 SELECT     `n`.`id` AS `novelID`,     `n`.`name` AS `novelName`,     `n`.`info` AS `introduction`,     group_concat(`t`.`name` SEPARATOR ',') AS `novelType`,     `n`.`author` AS ...
报错 SELECT list is not in GROUP BY clause
灵台方寸山斜月三星洞
08-17 1万+
[Err] 1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx' which is not functionally dependent on columns in GROUP BY clause; this is incompatible wit...
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
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
lxw1844912514的博客
09-18 4万+
报错:ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'work_ad.api_community_pic.id' which is not functionally dependent on columns in GROUP B...
Mysql解决SELECT list is not in GROUP BY clause and contains nonaggregated column 问题
皮蛋瘦肉的博客
03-15 5万+
在使用GROUP BY对Mysql的数据表进行查询时如果出现以下错误 select * from user group by age; ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.user.user_...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值