代码为：
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] Permulaan pantas Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
GROUP BY 出错-PHP中文网问答-GROUP BY 出错-PHP中文网问答
围观一下哦，学习一下。
sql_mode 的问题，改一下应该就可以了。
http://blog.csdn.net/wulantian/article/details/8905573