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-25 10:04:49 浏览: 307
mysql遇到Expression.docx
这是一个 MySQL 的错误信息,表示在使用 group by 语句时,order by 子句中的表达式 #1 不在 group by 子句中,并且包含的列 "information_schema.profiling.seq" 不是功能依赖于 group by 子句中的列;这与 sql_mode=only_full_group_by 不兼容。
阅读全文