Mysql的only_full_group_by

要求sql语句 满足group by对查询字段的要求(非聚集字段必须在group by(xxxx)中出现)的一个配置

select @@global.sql_mode;

去掉ONLY_FULL_GROUP_BY，重新设置值为

set @@global.sql_mode =’STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;

https://blog.csdn.net/myth_g/article/details/92831440