临时解决
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';
重新后还会出现
修改MySQL配置文件
Linux下my.cnf或Windows下My.ini
注意在[mysqld]段下添加以下代码:
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
- group only_full_group_by incompatible sql_mode columnsonly_full_group_by incompatible sql_mode group group only_full_group_by incompatible sql_mode only_full_group_by sql_mode mysql group only_full_group_by sql_mode版本 办法 only_full_group_by nonaggregated incompatible only_full_group_by functionally incompatible only_full_group_by aggregated函数sql_mode only_full_group_by sql_mode解决方案 版本 only_full_group_by only_full_group_by mysql group only