错误：myql5.7不兼容group by

报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘database_tl.emp.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方法：
方法一：修改mysql5.7的配置，将sql_mode中的ONLY_FULL_GROUP_BY去掉。
方法二：将数据库升级为8.0
方法三：修改使用到group by的sql语句
比如 SELECT id,code,name FROM a GROUP BY code;
改为 SELECT any_value(id),any_value(name),code FROM a GROUP BY code;