Mysql5.7或8.0 sql_mode=only_full_group_by

Posted by JJput on 07-05,2022

临时方法

mysql重启后会重置

Mysql 8.0

在Navicat中或者通过命令行进入数据库执行下面命令:

set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

Mysql 5.7

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

永久方法