61.11. this is incompatible with sql_mode=only_full_group_by

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.contact.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

不建議設定 SET sql_mode = ''，正确方式如下：

或者采用

原文出處：Netkiller 系列 手劄

本文作者：陳景峯

轉載請與作者聯系，同時請務必标明文章原始出處和作者資訊及本聲明。