基本/基本查询是:
SELECT SUM(field) AS AT, `table`.* FROM `table` WHERE id = '1';
我有一张有的桌子
field `id` mediumint(8)
field `field` int(12)
在我的本地MySQL 5.6.27中都运行FINE。
在远程MySQL 5.7.28中,我得到了以下错误:
#1140 - In aggregated query without GROUP BY,
expression #2 of SELECT list contains nonaggregated column
'BD.TABLE.id'; this is incompatible with sql_mode=only_full_group_by
从逻辑上讲,我不想在MySQL配置中更改/修改任何内容。
有可能修复QUERY的错误吗?
感谢
感谢{Nick,GMB}的帮助。当我将查询更改为:时
SELECT SUM(field) AS AT, `table`.* FROM `table` WHERE id = '1' GROUP BY `table`.`id`;
一切顺利。
(仅添加">GROUP BYtable
.id
"解决问题(
:-(