搜索

首页  >  问答  >  正文

GROUP BY 出错

代码为:

SELECT goods_id , goods_name FROM tdb_goods GROUP BY goods_name;

报错为:

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and con

tains nonaggregated column 't2.tdb_goods.goods_id' which is not functionally depen

dent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_g

roup_by


一辆想出轨的无轨电车一辆想出轨的无轨电车3023 天前1162

全部回复(2)我来回复

  • 数据分析师

    数据分析师2017-09-30 23:29:43

    GROUP BY 出错-PHP中文网问答-GROUP BY 出错-PHP中文网问答

    围观一下哦,学习一下。

    回复
    0
  • 巴扎黑

    巴扎黑2016-12-21 17:46:09

    sql_mode 的问题,改一下应该就可以了。

    http://blog.csdn.net/wulantian/article/details/8905573


    回复
    0
  • 取消回复