                        課程
                    
                        /數據庫
                        
                            /MySQL
                        
                        /與MySQL的零距離接觸

關于GROUP BY的問題

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tdb_goods.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

為什么不能用goods_name 分類呢

旗開得勝wds

2016-11-25

源自：與MySQL的零距離接觸 5-13

關注問題我要回答

1662

操作

收起

2 回答

qq_人來人往_7 回答被采納 +3 積分
2016-11-25

錯誤1055（42000）：表達# 1選擇列表不在GROUP BY子句包含非聚集列“tdb_goods。tdb_goods。goods_id '這是沒有功能依賴于列在GROUP BY子句；這是sql_mode = only_full_group_by不相容

0 回復有任何疑惑可以回復我~

收起回答

Alex2017
2017-04-12

You can try to disable the?only_full_group_by?setting by executing the following:

mysql>?set?global?sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
mysql>?set?session?sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

http://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql