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 error-PHP Chinese website Q&A-GROUP BY error-PHP Chinese website Q&A

Take a look and learn.

Answer 2

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

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