MySQL5.7 group by,报错1055
来源:互联网 发布:sql count用法 编辑:程序博客网 时间:2024/03/29 20:56
mysql> select @@sql_mode;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@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 |
+-------------------------------------------------------------------------------------------------------------------------------------------+
+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@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.00 sec)
配置文件添加
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
重新启动OK
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mysql5.6切换到5.7之后,突然发现原来的一些sql运行都报错,错误编码1055,错误信息和sql_mode中的“only_full_group_by“有关,到网上看了原因,说是mysql5.7中only_full_group_by这个模式是默认开启的
0 0
- MySQL5.7 group by,报错1055
- MySQL5.7 group by报错1055
- MySQL5.7 group by新特性,报错1055
- MySQL5.7 group by新特性,报错1055
- MySQL5.7 group by新特性,报错1055
- MySQL5.7 group by新特性,报错1055
- MySQL5.7 group by新特性,报错1055
- 关于mysql5.7 [Err] 1055 group by
- mysql5.7执行sql语句报错:In aggregated query without GROUP BY, expression #1 of SELECT list contains nonagg
- MySQL5.7排序后GROUP BY
- mysql5.7中group by限制
- oracle报错:不是GROUP BY 表达式
- mysql 查询group by 报错
- Ubuntu16.04里mysql5.7运行GROUP BY语句出现ERROR(1055):42000
- mysql5.7group by异常引发的思考
- ubuntu快速安装mysql5.7以及group by 问题
- hive报错 ParseException line 10:7 missing EOF at 'by' near 'group'
- 关于Oracle报错ORA-00979不是GROUP BY表达式
- 加载中...
- C++题库刷题数量统计
- loading
- linux shell bc命令 处理浮点数
- YUV to RGB Conversion
- MySQL5.7 group by,报错1055
- ios 将滚动视图中的图片拉出
- [必看]java 中变量存储位置的区别
- bzoj3562
- android:layout_gravity和android:gravity的区别
- JAVA设计模式:六大设计原则
- 写在开始学习机器学习之前
- 【Day41】php版微信发红包接口用法示例
- python内置函数|类中的内置方法|字符串内置方法大全