新建mysql 报only_full_group_by

[Err] 1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'qr.wb.unloading_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

 

 

解决方法:

打开mysql命令行:

select @@sql_mode;

查下结果:

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

编辑/etc/my.cnf文件:

删除查下结果中ONLY_FULL_GROUP_BY, 添加

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

 

posted @ 2018-08-13 15:02  vwater  阅读(156)  评论(0编辑  收藏  举报