msqyl5.6升级到mysql5.7报group_by问题解决方法

https://blog.csdn.net/qq_39174464/article/details/78988284

在数据库mysql那执行sql语句

 

 

 

 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';

set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; 
posted @ 2018-11-20 18:07  syy714363310  阅读(156)  评论(0编辑  收藏  举报