mysql5.7报错this is incompatible with sql_mode=only_full_group_by

org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘iemes_v1.li.item_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

先执行：
mysql> select @@global.sql_mode;
±------------------------------------------------------------------------------------------------------------------------------------------+
| @@global.sql_mode |
±------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
±------------------------------------------------------------------------------------------------------------------------------------------+

解决方法 ：
1，执行SET GLOBAL sql_mode = ‘’; 把sql_mode 改成非only_full_group_by模式。

mysql> SET GLOBAL sql_mode = ‘’;
Query OK, 0 rows affected, 1 warning (0.01 sec)

2，验证是否生效 SELECT @@GLOBAL.sql_mode 或 SELECT @@sql_mode
mysql> select @@global.sql_mode;
±------------------+
| @@global.sql_mode |
±------------------+
| |
±------------------+
1 row in set (0.00 sec)