this is incompatible with sql_mode=only_full_group_by 报错解决

原创 2018年04月17日 13:03:54

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘database_tl.emp.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

  • 临时解决方法
// 关掉ONLY_FULL_GROUP_BY!
set@@GLOBAL.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
  • 永久方法
// 修改my.ini
在 [mysqld]和[mysql]下添加
SET sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/millions_02/article/details/79973256

mysql下this is incompatible with sql_mode=only_full_group_by解决方案

本地测试没有问题,部署到客户服务器之后报如下错误:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of...
  • u012283400
  • u012283400
  • 2017-12-06 16:38:15
  • 501

mysql命令gruop by报错this is incompatible with sql_mode=only_full_group_by

今天在使用mysql命令行进行分组时报错: ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and...
  • tomcat_2014
  • tomcat_2014
  • 2016-11-28 18:12:24
  • 7760

Mysql this is incompatible with sql_mode=only_full_group_by 异常

数据库从5.5版本直接升级到了5.7版本,在执行Sql的时候出现异常  ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExcep...
  • u011687186
  • u011687186
  • 2017-07-26 14:28:37
  • 942

sql_mode=only_full_group_by研读

MySQL 5.7.5后only_full_group_by成为sql_mode的默认选项之一,这可能导致一些sql语句失效。比如下表game: id group_id name sc...
  • Allen_Tsang
  • Allen_Tsang
  • 2017-02-06 13:45:49
  • 12960

mysql5.7.9报错this is incompatible with sql_mode=only_full_group_by之解决

之前一直用的是5.6版本的mysql,最近升级到5.7.9之后之前运行挺正常的项目报错:which is not functionally dependent on columns in GROUP ...
  • a954274576
  • a954274576
  • 2017-06-12 14:10:38
  • 631

incompatible with sql_mode=only_full_group_by

使用mysql 5.7.11-debug Homebrew时报错 错误信息如下: 26 Mar 2016 09:35:23,432 ERROR org.hibernate.engine.jdbc....
  • hw1287789687
  • hw1287789687
  • 2016-03-27 03:26:06
  • 5045

mysql 5.7 this is incompatible with sql_mode=only_full_group_by 问题

1、查看sql_mode select @@sql_mode 查询出来的值为: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_Z...
  • qq_35160012
  • qq_35160012
  • 2017-06-21 09:16:38
  • 198

解决macOS下mysql的sql_mode=only_full_group_by问题

解决macOS下mysql的sql_mode=only_full_group_by问题原本在win10上运行的好好的sql语句,在Mac下执行带group by的命令时出现xxx……this is i...
  • Cooldiok
  • Cooldiok
  • 2017-03-01 20:34:47
  • 2934

Mysql only_full_group_by以及其他关于sql_mode原因报错详细解决方案

Mysql only_full_group_by以及其他关于sql_mode原因报错详细解决方案 网上太多相关资料,但是抄袭严重,有的讲的也是之言片语的,根本不连贯(可能知道的人确实不想多说...
  • wangyunfeis
  • wangyunfeis
  • 2017-09-09 10:57:55
  • 9578

[mysql] incompatible with sql_mode=only_full_group_by

> Error Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column...
  • sinat_28690417
  • sinat_28690417
  • 2017-05-21 16:14:05
  • 423
收藏助手
不良信息举报
您举报文章:this is incompatible with sql_mode=only_full_group_by 报错解决
举报原因:
原因补充:

(最多只允许输入30个字)