网站介绍：对于GROUP BY聚合操作，如果在SELECT中的列，没有在GROUP BY中出现，那么将认为这个SQL是不合法的，因为列不在GROUP BY从句中因为有only_full_group_by，所以我们要在MySQL中正确的使用group by语句的话，只能是select column1 from tb1 group by column1(即只能展示group by的字段，其他均都要报1055的..._错误代码: 1055 expression #1 of select list is not in group by clause and co
- 链接地址：https://blog.csdn.net/coco1118/article/details/103430320
- 链接标题：mysql 错误代码： 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated c_错误代码: 1055 expression #1 of select list is not in -CSDN博客
- 所属网站：blog.csdn.net
- 被收藏次数：3746
- 网站标签：错误代码: 1055 expression #1 of select list is not in group by clause and co
