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博客

网友收藏2023-10-13 06:48

链接地址：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
被收藏次数：9511

对于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://tebull.com/detail/90917.html

标签：错误代码: 1055 expression #1 of select list is not in group by clause and co