> 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains

使用查询：

select @@global.sql_mode

结果：

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,
NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

centos下修改：/etc/my.cnf文件

去掉ONLY_FULL_GROUP_BY，重新设置值

在末尾添加

[mysqld] 
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服务

service mysqld restart