遇到了异常:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方法
1,运行命令
SET GLOBAL sql_mode='';
2,设置mysql的配置文件,在/etc/my.cnf里
ps:这个设置是mysql5.7.5版本之后默认加入的,在mysql5.7.11里show global variables like "sql_mode",得到如下的结果:
(这个系统显示貌似有点问题)