数据库升级group by问题解决!

解决地址:

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

 

解决方法:

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 @ 2020-11-26 10:41  syy714363310  阅读(77)  评论(0编辑  收藏  举报