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