MySQL-5.7.28分组时报错1055

问题

问题描述

错误代码： 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ht-3.0.project_info.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方法

运行这段代码即可

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));