程序员的每一天的博客

GROUP_CONCAT 连接两个分组的字符创

#1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xubao.a.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by** 数据库5.7版本问题 取消数据库only_full_group_by这个设定 且

查看mysql的状态 service mysql status 重启mysql service mysql restart 停止 service mysql stop 4.启动 service mysql start

1.官网下载linux包 2.右键复制链接地址使用wget下载 wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz 3.下载的文件解压 tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz 4.把文件移动linux常用安装目录 并重命名 mv /root/mysql/mysql-5.7.30-linux-glibc