mysql
邀得一夜星河枕
这个作者很懒,什么都没留下…
展开
-
linux-CentOS下 普通用户安装mysql-5.7.x
下完安装包mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz后,通过rz上传至linux的wlf用户soft目录下,并解压:$ cd soft$ rz$ cd ..$ tar zxvf soft/mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz创建软连接:$ ln -s mysql-5.7.27-linux...转载 2020-04-09 14:14:17 · 489 阅读 · 0 评论 -
Mysql SELECT list is not in GROUP BY clause and contains nonaggregated column 问题
第一种重启mysql会失效:在使用GROUP BY对Mysql的数据表进行查询时如果出现以下错误select * from user group by age;ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clauseand contains nonaggregated column 't...原创 2019-10-18 11:32:26 · 295 阅读 · 0 评论