阿里云数据库 用groupby 报错 怎么解决?
Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sport.pe_plans.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SQL: select * from pe_plans
where type
= 1 and pe_plans
.deleted_at
is null group by type
) in file C:\Users\dada\Desktop\zz\code\sport\vendor\laravel\framework\src\Illuminate\Database\Connection.php on line 742
在嚴格模式下 因為你的select的列 沒有被GROUP BY 的列所包含 可以在config/database.php的mysql配置中把 strict 設置為false