关于mysql语句不兼容问题，如何优化语句？
关于mysql版本不兼容问题，如何优化？
mysql版本： Ver 14.14 Distrib 5.7.28, for Win64 (x86_64)
执行语句：
mysql> 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 contains nonaggregated column 'test.tdb_goods.goods_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
