欢迎光临
感谢一路有你

mysql5.7,用group by 查询时抛出如下异常

如果你对该文章中的内容有疑问/不解,可以点击此处链接提问
要注明问题和此文章链接地址 点击此处跳转
 

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘kanxf.o.down_uid’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决办法

第一步

第二步

赞(0) 打赏
未经允许不得转载:王明昌博客 » mysql5.7,用group by 查询时抛出如下异常
分享到: 更多 (0)

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏