Mysql的sql_mode=only_full_group_by问题解决
程序员文章站
2023-12-28 11:52:52
...
[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
解决方法
在Navicat的编辑器中输入
select version(), @@sql_mode;
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
重启即可解决错误推荐阅读
-
“this is incompatible with sql_mode=only_full_group_by“问题解决
-
sql_mode=only_full_group_by问题解决
-
Mysql的sql_mode=only_full_group_by问题解决
-
MySQL5.7版本sql_mode=only_full_group_by问题解决办法
-
mysql高版本 出现this is incompatible with sql_mode=only_full_group_by
-
mysql only_full_group_by以及其他关于sql_mode原因报错详细解决方案
-
MySQL sql_mode=only_full_group_by错误
-
Mysql高版本报sql_mode=only_full_group_by异常
-
mysql:sql_mode=“only_full_group_by”
-
MYSQL8.0 排序查询报错 this is incompatible with sql_mode=only_full_group_by