[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information

在Navicat Premium中执行Mysql的一条删除语句，虽然执行成功了，却提示已下错误:

受影响的行: 1

时间: 0.005s

[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

我们查看一下sql_mode的信息

SHOW VARIABLES LIKE 'sql_mode%'

确实有only_full_group_by这个值。

我们去配置文件中删除这个变量配置

编辑my.ini或my.inf

[mysqld]

sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

保存，重启MySQL后warning信息消失。

巴特西

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ'

最新文章

热门文章