Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column【bug】解决方案
问题场景:
select stuid from student_table GROUP BY stuAccount HAVING count(stuAccount)>1;
运行完这条sql语句后mysql就报了这个错误。
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column…
解决方案:
1.对于已经存在的数据库
执行下面的sql语句即可(没有效果重启数据库服务)
SE
原创
2022-03-29 15:35:55 ·
1410 阅读 ·
2 评论