[err] 1055 - expression #1 of order by clause is not in group by clause and contains nonaggregated column 'information_schema.profiling.seq' which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by
时间: 2023-04-29 13:04:47 浏览: 175
MySQL异常:[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nona…
5星 · 资源好评率100%
这是一个 MySQL 数据库错误,表示在使用 ORDER BY 子句时,在 GROUP BY 子句中缺少了一个 non-aggregated 列。在 sql_mode 设置为 only_full_group_by 时会引发这个错误。解决方法是在 ORDER BY 子句中加入与 GROUP BY 子句中相同的列或在 GROUP BY 子句中加入需要排序的列。
阅读全文