com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXXX.T.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
因为出差,我把项目数据导出来放我本地做测试,结果遇到这个问题,看着代码也没错,懵比了很久,百度了一下才知道,我的mysql版本是5.7.11,项目的是5.6.几,在5.7以上的版本实现了对功能依赖的检测,MySql默认启用了only_full_group_by SQL模式,所以出来这个错。。。
解决MySql查询语句报Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre异常的问题
但是处理的结果是
结果发现。。。set @@global.sql_mode后面多了个空格
(⊙o⊙)…