MySQL分组查询时出现错误SELECT list is not in GROUP BY ;this is incompatible with sql_mode=only_full_group_by
来源:互联网 发布:mac版的photoshop cc 编辑:程序博客网 时间:2024/05/21 22:51
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'chapter04.student.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方法:
修改MySQL的配置文件
vi /etc/mysql/my.cnf
添加语句sql_mode='NO_ENGINE_SUBSTITUTION'
然后重启数据库 /etc/init.d/stop /etc/init.d/start
阅读全文
0 0
- MySQL分组查询时出现错误SELECT list is not in GROUP BY ;this is incompatible with sql_mode=only_full_group_by
- mysql查询报错: ORDER BY clause is not in GROUP BY..this is incompatible with sql_mode=only_full_group_by
- mysql查询报错: ORDER BY clause is not in 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
- this is 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解决方案
- 解决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命令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
- 线程安全总结
- 贪吃蛇-----小游戏
- 获取SessionFactory的工具类
- JavaScript Math 对象
- 自定义相机旋转拍照角度
- MySQL分组查询时出现错误SELECT list is not in GROUP BY ;this is incompatible with sql_mode=only_full_group_by
- ppt后续更新模板(二)说明
- 练习赛ming最优安排(贪心)
- testNG入门教程
- 在二叉查找树中插入节点-LintCode
- PHP递归无限分类
- 用RecyclerView多布局实现购物车+随便逛一逛
- JavaScript的prototype
- python将某一目录下的多个文件合并为一个文件