GROUP BY 出错

Question

代码为：

SELECT goods_id , goods_name FROM tdb_goods GROUP BY goods_name;

报错为：

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and con

tains nonaggregated column 't2.tdb_goods.goods_id' which is not functionally depen

dent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_g

roup_by

Answer 1

GROUP BY 오류-PHP 중국어 웹사이트 Q&A-GROUP BY 오류-PHP 중국어 웹사이트 Q&A

보시고 배워보세요.

Answer 2

sql_mode 的问题，改一下应该就可以了。

http://blog.csdn.net/wulantian/article/details/8905573