随笔分类 - MySQL
摘要:使用group by分组时,查询字段没有分组的字段就会报错 [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.user.id' whi
阅读全文
摘要:mysql5.7使用group by分组时,查询字段没有分组的字段就会报错 [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.user
阅读全文
摘要:1.mysql登录 连接认证基本语法: mysql -h主机地址 -P端口 -u用户名 -p密码 示例:mysql -h localhost -u root -pwang 注意事项 1、 通常端口都可以默认:mysql默认的端口通常都是3306 2、 密码的输入可以先输入-p,直接换行,然后再以密文
阅读全文
摘要:问题: [root@localhost mysql]# mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mys
阅读全文
摘要:1.mysql-5.7.25-1.el6.x86_64.rpm-bundle.tar下载百度云资源 百度云:https://pan.baidu.com/s/1Sfom_aNhTyZnR7KGTZIfFw 提取码:ej1y 2.把下载的mysql安装包上传到Centos上 解压mysql,我这是在Wi
阅读全文