MySQL sql_mode=only_full_group_by 问题

错误信息：

Expression #2 of SELECT list is not in GROUP BY clause and contains 
nonaggregated column XXXX which is not functionally 
dependent on columns in GROUP BY clause; this is incompatible with 
sql_mode=only_full_group_by

执行命令：

select @@global.sql_mode;

看查询结果是否有：ONLY_FULL_GROUP_BY
去掉ONLY_FULL_GROUP_BY，重新设置值

set @@global.sql_mode = ' STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

关闭连接，重新连接，查询成功