1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema
程序员文章站
2022-03-23 23:15:50
...
1 解决 ORDER BY clause is not in GROUP BY
update时出现下面的问题，然后很自然的去百度，他们说需要改模式或者配置文件。但是我之前update时都是可以的，凭什么过了半天就不行了，于是从sql语句查问题，结果sql语句也没错，那究竟是什么问题呢，我也不知道为啥突然报错，解决方法重启nvicat即可。
反正我是重启之后就能成功执行。
不建议改mysql的配置。
1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema
推荐阅读
-
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL
-
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
-
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.
-
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
-
报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
-
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains解决
-
idea报错 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
-
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题 MySQL
-
解决大于5.7版本mysql的分组报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
-
【问题解决】Expression #30 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zxj