本文共 581 字，大约阅读时间需要 1 分钟。

 mysql5.7之后使用 group by 会出现 only_full_group_by

### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'user.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方案

# 编辑/etc/my.cnf$ vi /etc/my.cnf# /etc/my.cnf 文件最后添加下面的命令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$ service mysqld restart

 

转载地址：http://liyvb.baihongyu.com/