Error:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rzk_

记录Java学习的三木

于 2025-08-06 16:18:10 发布

阅读量190

点赞数 7

CC 4.0 BY-SA版权

分类专栏： MySQL 文章标签：数据库

本文链接：https://blog.csdn.net/qazwsxplmtgb/article/details/149974083

MySQL 专栏收录该内容

3 篇文章

订阅专栏

Error:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rzk_shop_cms.cms_content.content_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


意思就是select语句中查询的列,要么出现在group by 中,要么用聚合函数关联
比如

SELECT id, content_title, content_description 
FROM cms_content 
WHERE content_tags LIKE CONCAT('%',?,'%') 
  AND content_tags LIKE CONCAT('%',?,'%') 
  AND content_publish_status=1 
  AND del=0 
GROUP BY id 
ORDER BY content_datetime DESC
像这样,但是这样改会一宿sql语句语意

更好的处理方案