show variables like '%sql_mode%'; | |
---|---|
Variable_name | Value |
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 |
1 row in set (0.01 sec)
ONLY_FULL_GROUP_BY:表示什么意思?
我在lepus天兔数据库监控平台监控这台mysql服务器状态时lepus日志报错:
2019-08-20 14:31:32 [WARNING] check mysql 192.XXX.XXX.54:3306 failure: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'information_schema.processlist.USER' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
不知道什么原因,不知道这种报错是表示什么意思,查看sql_mode 这台服务器上比别的mysql多了个ONLY_FULL_GROUP_BY,请问能否删除这个sql_mode?删除后会有什么影响吗?