1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tes

文章目录

今天在开发过程中，由于之前项目已经开发完成，完成了数据库迁移，今天在操作的时候，根据分组求和的时候，出现了一个错误：

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'btc.a.applicant_unit' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.sys_user.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决

一番操作之后，终于找出了解决方案：
在MySQL下输入如下语句

set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

然后重新运行语句，就可以正常查询了。