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

解决方法:
暂时没有解决

相关文章
|
数据库
解决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
315 0
|
关系型数据库 MySQL
报错sql_mode=only_full_group_by
报错sql_mode=only_full_group_by
|
SQL 数据库
this is incompatible with sql_mode=only_full_group_by
this is incompatible with sql_mode=only_full_group_by
101 0
|
SQL 关系型数据库 MySQL
sql_mode中的ONLY_FULL_GROUP_BY的作用
MySQL 8中的sql_mode中的默认值如下
622 0
|
SQL 关系型数据库 MySQL
this is incompatible with sql_mode=only_full_group_by、错误解决方案(亲测可用)
this is incompatible with sql_mode=only_full_group_by、错误解决方案(亲测可用)
4224 0
this is incompatible with sql_mode=only_full_group_by、错误解决方案(亲测可用)
|
SQL 关系型数据库 MySQL
MySQL中出现sql_mode=only_full_group_by问题解决
在 MySQL 5.7 以上的版本中 sql_mode 新加入了 only_full_group_by,导致我们在使用 group by 函数的时候,则会报错
361 0
MySQL中出现sql_mode=only_full_group_by问题解决
|
关系型数据库 MySQL
MySQL:报错 ERROR 1055 (42000)sql_mode=only_full_group_by
MySQL:报错 ERROR 1055 (42000)sql_mode=only_full_group_by
237 0