[Bug0038]mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...解决方案

1、问题

SQL 错误 [1055] [42000]: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'station.sw.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

2、场景

3、原因

4、解决方案

参考

参考

posted @ 2022-07-29 17:01  Code7Rain  阅读(25)  评论(0)  编辑  收藏  举报