解决Mysql在查询时报：1055分组查询错误的解决方法

SELECT name,phone FROM sys_user
GROUP BY name HAVING COUNT(1) >= 2

> 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gas_web_gb.B.parent_module_code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
> 时间: 0.008s

是由于默认的 MySQL 配置中 sql_mode 配置了 only_full_group_by，需要 GROUP BY 中包含所有 在 SELECT 中出现的字段。

SELECT @@sql_mode;