Mysql 8.x [Err] 1055 only_full_group_by 问题记录

查询时报错 [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '

SELECT c.* ,COUNT(courseId) as cnum FROM center_coursetime c WHERE isDel=0  GROUP BY schoolId ORDER BY c.createTime DESC
           

解决方法：

登录mysql 后可以查看sql_mode

show variables like '%sql_mode%';

其中ONLY_FULL_GROUP_BY 就是引起问题的关键

在 mysql配置文件中/etc/my.cnf中加入

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

重启服务，问题解决

版权声明：本文为CSDN博主「weixin_34032779」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。

原文链接：https://blog.csdn.net/weixin_34032779/article/details/91900837