源自:-
关于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