mysql 5 this is incompatible wit

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

执行以下语句将only_full_group_by去掉

set @@GLOBAL.sql_mode='';
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';

注有数据连接池连接时还是会报错，重启下应用程序即可，