报错: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;