mysql分组时出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre

报错：
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wlhy.c.com

mysql分组时出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre

在mysql里面执行命令

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

设置sql_mode，把ONLY_FULL_GROUP_BY替换成空的。

问题产生的原因：
可能是用docker安装的mysql出现问题，不建议用docker安装mysql数据库