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

this is incompatible with sql_mode=only_full_group_by

MySQL版本5.7.14;

SQL语句:

mysql> SELECT id,sex,age FROM users_0 GROUP BY age;

ERROR:

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

似乎在SELECT后的字段必须全部出现在GROUP BY之后,否则都会出现以上错误.

请问什么原因,如何解决?

陈某人路过

2016-08-24

源自：与MySQL的零距离接触 4-9

关注问题我要回答

1527

操作

收起

2 回答

heruibin322 回答被采纳 +3 积分
2016-08-24

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';
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';