[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 的问题 MySQL

mysql版本：8.0.16

navicat版本：11.1.3

执行update语句 报错：MySql遇到 [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

尝试在my.ini文件中配置sql_mode没有用

解决方法：

cmd

mysql -hlocalhost -uroot -p回车 输入密码 进入mysql命令行

输入：mysql> select @@sql_mode; 

查询结果： sql_mode=only_full_group_by……（后省略）

输入：set @@global.sql_mode ='';

执行结果：1 row in set

关闭重新打开navicat 执行之前的报错语句 不再报错1055