ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema
来源：互联网 发布：电脑印章的软件 编辑：程序博客网 时间：2024/06/05 04:59
今天打开 navicat运行一个update语句时，出现已经update成功，但是会报如下错误：
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by在网上找了好久的办法，特此记录。
第一步、打开查询界面输入select语句：
select version(), @@sql_mode;第二步、在输入如下语句：
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));第三步、重新执行update语句
update *** set ***=XXX where id=***这样就可以解决问题了，亲测有效。但是我还不是很理解这样操作的原因，找到一篇相应的文章，用来参考。
http://blog.csdn.net/u014520745/article/details/76056170
阅读全文
0 0
- ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema
- Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'inform
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated..
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
- SELECT list is not in GROUP BY clause and contains nonaggregated column
- MySQL： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '
- Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.
- #1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i
- [mysql] Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lo
- MySQL: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sss
- Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.tdb_
- Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
- jdbc4.MySQLSyntaxErrorException:Expression #2 of SELECT list is not in GROUP BY clause and contains
- MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
- ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
- mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
- 自定义View之LOL能力七星图
- JZOJ 5421. 【NOIP2017提高A组集训10.25】嘟嘟噜
- c语音代码及注释“俄罗斯方块”
- C#中HttpWebRequest的用法详解
- Java转义字符详细、Eclipse快捷键详细、Eclipse的javadoc文档操作
- ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema
- JAVA连接Orcale数据库
- Android读书笔记（五）使用摄像头、从相册获取图片
- QT编写树莓派的Nokia5110显示屏显示
- Go语言中数组和slice的区别
- Properties工具类
- moment.js 日期和时间管理 24小时制
- bzoj 1978（dp）
- 线性表
