Linux下使用mysql5.7出现这个错误：mysql column which is not functionally dependent GROUP BY clause

解决办法：

1、首先查询

show variables like "sql_mode";

mysql column which is not functionally dependent GROUP BY clause_mysql

2、复制sql-mode的Value,添加到 /ect/my.cnf配置文件中的[mysqld]下.

mysql column which is not functionally dependent GROUP BY clause_数据库_02

3、然后重启数据库

systemctl restart mysqld.service