which is not functionally dependent on columns in GROUP BY clause； this is incompatible with sql_mo

参考：https://www.cnblogs.com/chcha1/p/12996860.html
博主：ZeroGirl

mysql 执行报错：Error querying database. Cause: java.sql.SQLSyntaxErrorException:which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

原博文中还有其他方式！

最终解决办法：修改MySQL的配置文件
在linux服务上用docker安装的mysql，进入mysql容器中，进入/etc/mysql目录下修改my.cnf文件 在 [mysqld] 下面添加代码：

vim /mydata/mysql/conf/my.cnf

[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

重启Mysql

docker restart mysql