Navicat执行SQL语句提示：[Err] 1055 ... ql_mode=only_full_group_by...

Navicat执行SQL语句提示：[Err] 1055 … ql_mode=only_full_group_by…

Navicat执行SQL语句提示：[Err] 1055 … ql_mode=only_full_group_by…

譬如：[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

# 执行下面语句

1. 先查看本地sql_mode

select @@sql_mode

查出来的结果为：

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

1. 上面查出的结果删除相应的sql_mode=only_full_group_by

select @@sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

每次执行新的查询语句都要执行‘2步骤’，这样每次执行其他SQL语句就不会报1055报错啦