![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
鹿指为码
努力!奋斗!
展开
-
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated
错误信息:[Err] 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scp.m.manufacturer_id' which is not functionally dependent on columns in GROUP BY clause;...原创 2019-03-30 23:52:10 · 7889 阅读 · 0 评论 -
MYSQL修改最大连接数 ["Too many connections"]
"Too many connections"话不多说,开始解决问题。1.我们可以运用如下代码查看数据库当前最大连接数 show variables like '%max_connections%';结果如下:(PS:默认值是100,我的是已经修改好了的)。2.再使用如下代码查看数据库当前已经连接数show global status like 'Max_used_...原创 2018-10-06 21:40:26 · 329 阅读 · 0 评论