mysql问题解决SELECT list is not in GROUP BY clause and contains nonaggregated column

2023-01-05 10:57:14

今天在Ubuntu下的部署项目，发现一些好好的列表页面发生

1055:Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ppm_c.ppm_flow_starting_dealing.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

 

上一篇：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated


下一篇：运行报错Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column xx....