incompatible with sql_mode=only_full_group_by

简介: <div class="markdown_views"><p>使用mysql 5.7.11-debug Homebrew时报错 <br>错误信息如下: <br>26 Mar 2016 09:35:23,432 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper:147 - Expression #1 of SELE

使用mysql 5.7.11-debug Homebrew时报错
错误信息如下:
26 Mar 2016 09:35:23,432 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper:147 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tv2.t_pic_news_one.pic_path’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决方法:
暂时没有解决

目录
打赏
0
0
0
0
1132
分享
相关文章
解决which is not functionally dependent on columns in GROUP BY clause;...sql_mode=only_full_group_by
解决which is not functionally dependent on columns in GROUP BY clause;...sql_mode=only_full_group_by
367 0
this is incompatible with sql_mode=only_full_group_by
this is incompatible with sql_mode=only_full_group_by
106 0
this is incompatible with sql_mode=only_full_group_by、错误解决方案(亲测可用)
this is incompatible with sql_mode=only_full_group_by、错误解决方案(亲测可用)
4338 0
this is incompatible with sql_mode=only_full_group_by、错误解决方案(亲测可用)
MySQL中出现sql_mode=only_full_group_by问题解决
在 MySQL 5.7 以上的版本中 sql_mode 新加入了 only_full_group_by,导致我们在使用 group by 函数的时候,则会报错
382 0
MySQL中出现sql_mode=only_full_group_by问题解决

热门文章

最新文章

AI助理

你好,我是AI助理

可以解答问题、推荐解决方案等