MySQL语句兼容性太差_关于mysql语句不兼容问题，如何优化语句？

源自：-

关于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

提问者：Domcraman

2019-11-29 10:45