MySql 查询时[Err] 1055错误的解决方案

[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'emd.y.tiid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

在执行mysql查询的时候报了这个错误，大概是因为mysql的严格模式导致的，我们的学习的时候都知道

出现在mysql查询语句里的字段，如果后面跟了group by 语句，那第查询字段要么是group by 的条件，要么是聚全函数里的才可以 

修改mysql配置，在my.conf下mysqld里添加如下配置ok

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

登录mysql查看

mysql> select version(), @@sql_mode;
+-----------+--------------------------------------------+
| version() | @@sql_mode                                 |
+-----------+--------------------------------------------+
| 5.7.28    | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+-----------+--------------------------------------------+
1 row in set (0.00 sec)

再重启mysql再执行sql 就可以啦