                        课程
                    
                        /数据库
                        
                            /MySQL
                        
                        /与MySQL的零距离接触

mysql> 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 c

ontains nonaggregated column 'imooc.tdb_goods.goods_id' which is not functionall

y dependent on columns in GROUP BY clause; this is incompatible with sql_mode=on

ly_full_group_by

qq_慕丝5068290

2018-12-12

源自：与MySQL的零距离接触 5-14

关注问题我要回答

2627

操作

收起

1 回答

慕码人1374312
2018-12-15

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

1 回复有任何疑惑可以回复我~

收起回答

0/150

提交

取消

与MySQL的零距离接触

参与学习 396727 人
解答问题 3497 个

本课程涵盖全部MySQL数据库的基础，学习MySQL数据库的基础知识

进入课程

mysql> SELECT goods_id,goods_name FROM tdb_goods GROUP BY goods_name;

我要回答关注问题

热搜

最近搜索清空

mysql> SELECT goods_id,goods_name FROM tdb_goods GROUP BY goods_name;

1 回答

mysql> SELECT goods_id,goods_name FROM tdb_goods GROUP BY goods_name;