MySQL报错:SELECT list is not in GROUP BY clause and contains nonaggregated column,解决ONLY

MySQL报错:SELECT list is not in GROUP BY clause and contains nonaggregated column,解决ONLY

报错截图

解决方法：修改数据库配置

1.查看.sql_mode配置
select @@global.sql_mode;

2.查看返回信息是否包含ONLY_FULL_GROUP_BY
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION;

3.去掉ONLY_FULL_GROUP_BY ，其他参数不变，执行即可
SET GLOBAL sql_mode=‘STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION’;

。