                        课程
                    
                        /数据库
                        
                            /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

关注问题我要回答

1629

操作

收起

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