SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;
![](https://img.haomeiwen.com/i1351616/f6bf22db43fe4ac0.png)
执行以下语句将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';
![](https://img.haomeiwen.com/i1351616/6f73f72b79d3cab7.png)
注有数据连接池连接时还是会报错,重启下应用程序即可,
网友评论