1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains解决

今天在开发过程中,由于之前项目已经开发完成,完成了数据库迁移,今天在操作的时候,根据分组求和的时候,出现了一个错误:
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

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

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

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

上一篇:数据库缓冲池(Buffer Pool)


下一篇:内存分析(二) AVFrame