代码为：
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
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
GROUP BY error-PHP Chinese website Q&A-GROUP BY error-PHP Chinese website Q&A
Take a look and learn.
sql_mode 的问题，改一下应该就可以了。
http://blog.csdn.net/wulantian/article/details/8905573