[mysql] incompatible with sql_mode=only_full_group_by
来源:互联网 发布:网络电视伴侣apk 编辑:程序博客网 时间:2024/05/30 20:07
> Error
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
> 背景
- java-mysql-connect-5.1.41.jar- 5.7.18 mysql-version- Linux- Tomcat7.0- jdk1.7
>解决方法- 1. 升级mysql-java-connect版本- 2. 在/etc/my.cnf中添加或修改
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
其他
Linux下/etc/my.cnf中其他关于mysql的常见配置说明
阅读全文
0 0
- [mysql] incompatible with sql_mode=only_full_group_by
- incompatible with sql_mode=only_full_group_by
- MySQL Error this is incompatible with sql_mode=only_full_group_by
- mysql 5.7 this is incompatible with sql_mode=only_full_group_by 问题
- Mysql this is incompatible with sql_mode=only_full_group_by 异常
- mysql下this is incompatible with sql_mode=only_full_group_by解决方案
- this is incompatible with sql_mode=only_full_group_by
- this is incompatible with sql_mode=only_full_group_by
- this is incompatible with sql_mode=only_full_group_by
- 解决MySQL 5.7.9版本sql_mode=only_full_group_by问题,this is incompatible with sql_mode=only_full_group_by错误
- mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
- 【mysql 使用错误解决】this is incompatible with sql_mode=only_full_group_by
- mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
- mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
- mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
- mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
- mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
- mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by
- Jdk1.8中ConcurentHashMap实现策略的变化
- Java中成员变量与局部变量的比较
- 抽象和接口
- FastCgi与PHP-fpm之间的关系
- 正则表达式常用符号
- [mysql] incompatible with sql_mode=only_full_group_by
- artoolkit从读取摄像头改为读取视频文件或图像
- ajax跨域
- 树的高度
- angular指令之complie和link不得不说的故事
- Python-sklearn 机器学习的第一个样例(7)
- 最大数与最小数调换位置
- 一步步带你,如何网站架构
- unity富文本