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

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.tb1.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.tb1.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

zsfen

2016-11-15

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

关注问题我要回答

8120

操作

收起

3 回答

loveying 回答被采纳 +3 积分
2016-11-15

可以放源代码？

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

#1

zsfen 提问者

非常感谢！

2016-11-16 回复有任何疑惑可以回复我~

太阳之城
2017-07-31

sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

--------------------------------------------------------------------------------

在my.ini中加上这句话就行了

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

#1

嗯谢谢~！

2017-08-04 回复有任何疑惑可以回复我~

#2

有用！请问是什么原因？

2017-11-24 回复有任何疑惑可以回复我~

zsfen 提问者
2016-11-16

不懂什么意思

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

举报

0/150

提交

取消

与MySQL的零距离接触

参与学习 396886 人
解答问题 3353 个

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

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't1.tb1.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

我要回答关注问题

意见反馈帮助中心 APP下载