[bug]SQLSTATE[42000]: .....this is incompatible with sql_mode=only_full_group_by

问题：

阿里云数据库配置问题导致php报错，mysql版本5.7

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yltj.c.target' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

修复：

在阿里云控制台修改

删掉 @@global.sql_mode 配置

2、本地数据库的话直接执行下面的语句

set @@global.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

//或者


set @@global.sql_mode='';