美文网首页
incompatible with sql_mode=only_

incompatible with sql_mode=only_

作者: mejhwu | 来源:发表于2018-01-11 15:08 被阅读0次
错误详情

Caused by: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'message.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方案

参考https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql

相关文章

网友评论

      本文标题:incompatible with sql_mode=only_

      本文链接:https://www.haomeiwen.com/subject/fsttoxtx.html