mysql Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre
一,问题现象 在mysql中,用group by 分组时 报错Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre,运行的sqlselect a.id, a.name, a.agefrom agroup by id, name这个主要是违背了mysql开启的校验only_full_group_by 检测二,问题的本质这个问题主要是mysql 开启了onl...
原创
2021-10-21 10:33:52 ·
13720 阅读 ·
0 评论