首页 > 数据库技术 > 详细

mysql问题解决SELECT list is not in GROUP BY clause and contains nonaggregated column

时间:2019-03-31 16:55:18      阅读:1373      评论:0      收藏:0      [点我收藏+]

标签:好的   sql_mode   start   nbsp   which   pre   发生   cti   agg   

今天在Ubuntu下的部署项目,发现一些好好的列表页面发生

1055:Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column ppm_c.ppm_flow_starting_dealing.status which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 

 

mysql问题解决SELECT list is not in GROUP BY clause and contains nonaggregated column

标签:好的   sql_mode   start   nbsp   which   pre   发生   cti   agg   

原文:https://www.cnblogs.com/baby123/p/10631936.html

(0)
(0)
   
举报
评论 一句话评论(0
© 2014 bubuko.com 版权所有 鲁ICP备09046678号-4
打开技术之扣,分享程序人生!
             

鲁公网安备 37021202000002号