yuliqi asked 7 年 ago
数据库版本 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的参数,请问还有没有更好的办法? 非常感谢
在执行 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的参数,请问还有没有更好的办法? 非常感谢
oneinstack