当前位置: 代码迷 >> 综合 >> 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xin
  详细解决方案

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xin

热度:91   发布时间:2023-11-08 17:58:20.0

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xinwu_carnation.pm.moplan_time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

执行SQL,报上面的错误,进而了解到sql_mode,找到一篇讲解的文章,后面找时间认真学习一下;

链接

  相关解决方案