1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated 【已解决】
文章目录
- 解决
今天在开发过程中，由于之前项目已经开发完成，完成了数据库迁移，今天在操作的时候，根据分组求和的时候，出现了一个错误：
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_by1055 - 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';
然后重新运行语句，就可以正常查询了。
╰+攻爆jí腚メ
梦里梦外;
亦凉
爱被打了一巴掌
超、凢脫俗
野性酷女
还没有评论，来说两句吧...