                        课程
                    
                        /数据库
                        
                            /MySQL
                        
                        /与MySQL的零距离接触

GROUP BY错误

mysql> SELECT sex,age FROM users GROUP BY 1 HAVING age>35;

ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.users.age' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

mysql> SELECT sex,age FROM users GROUP BY 1 HAVING age>35;

这是为什么

ap0stader

2017-03-24

源自：与MySQL的零距离接触

关注问题我要回答

1007

操作

收起

1 回答

Apollo1616
2018-10-16

mysql> select age from userinfo group by gender;
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and c
ontains nonaggregated column 'apollo.userinfo.age' which is not functionally dep
endent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by