MYSQL5.7版本sql_mode=only_full_group_by问题

Mysql 5.7.x 版本查询报错：
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'a.dayy' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方法：

1. 登录Mysql，对sql_mode进行设置

   mysql> SELECT @@sql_mode;
   +-------------------------------------------------------------------------------------------------------------------------------------------+
   | @@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 row in set (0.00 sec)
   
   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 row in set (0.00 sec)
   

   设置session级别

   mysql> SET 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 服务重启后，sql_mode设置无效)

   mysql> SET @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
   

2. 修改Mysql配置文件/etc/my.cnf (Linux) 或 my.ini (Windows) (永久生效)

   [mysqld]
   ...
   ql_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