查看mysql的sql_mode
select @@GLOBAL.sql_mode
查询结果如果如下,则为开启ONLY_FULL_GROUP_BY验证,
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
设置sql_mode
在配置文件中添加如下配置,关闭ONLY_FULL_GROUP_BY,关闭后group by查询就正常了
[mysqld]
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'