数据库错误ERROR 1055 (42000): Expression #1 of ORDER BY clause is not in GROUP BY

用的这篇文章的方法解决滴：
https://blog.csdn.net/jgj0129/article/details/53420574

这里就是自己再记录一下。加粗的就是用到的语句。

mysql> select dept_name,avg(tot_cred) from student
-> group by dept_name having avg(tot_cred)>80 order by(tot_cred) desc;
ERROR 1055 (42000): Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘mylab.student.tot_cred’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
mysql> show variables like ‘%sql_mode%’;
±--------------±----------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
±--------------±----------------------------------------------------------------------------------------------------------------------+
| sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
±--------------±----------------------------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.02 sec)

mysql> set sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,’’));
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like ‘%sql_mode%’;
±--------------±---------------------------------------------------------------------------------------------------+
| Variable_name | Value |
±--------------±---------------------------------------------------------------------------------------------------+
| sql_mode | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
±--------------±---------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

mysql> select dept_name,avg(tot_cred) from student
-> group by dept_name having avg(tot_cred)>80 order by(tot_cred) desc;
±----------±--------------+
| dept_name | avg(tot_cred) |
±----------±--------------+
| Biology | 120.0000 |
| Finance | 110.0000 |
±----------±--------------+
2 rows in set (0.01 sec)