执行 update 时 出现1055错误

问答中心分类: Database执行 update 时 出现1055错误
yuliqi 提问 2年 前

数据库版本 5.7.17-log MySQL Community Server (GPL)
在执行 UPDATE `wd_devices_copy` SET `status` = ‘3’ where id = 3 时报以下错误
[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的参数,请问还有没有更好的办法? 非常感谢