![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql数据库
dongxindadida
这个作者很懒,什么都没留下…
展开
-
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is no
启动项目报错:Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is no…解决方法:cmd root账号进入mysql在mySQL里面执行命令SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));或者使用其他的连接工具连接上也可以(需要root权限);...原创 2021-12-02 19:03:33 · 4171 阅读 · 0 评论 -
Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and
报错内容:Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘hc_community.ms.community_member_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompa原创 2021-11-16 14:40:42 · 2734 阅读 · 0 评论