技术教程 编程教程 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 正文

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column

2023-04-25,,

Error:
javax.servlet.ServletException: java.sql.SQLSyntaxErrorException: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'invest.b.fund_abbr_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
 

mysql>
 
Solution:
select @@global.sql_mode;
 
set @@global.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column的相关教程结束。

《Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column.doc》

下载本文的Word格式文档，以方便收藏与打印。

Copyright 2023. 昆居客 - IT编程,互联网信息技术文档大全!