weixin_45639174的博客

select *,if(@salary=salary,@rank:=@rank+1,@rank:=1),@salary:=salary from (select * from test order by salary) a,(select @salary:=0,@rank:=0) b;

下载并安装MySQL官方的 Yum Repository wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm 使用上面的命令就直接下载了安装用的Yum Repository，大概25KB的样子，然后就可以直接yum安装了。 yum -y install mysql57-community-release-el7-10.noarch.rpm 之后就开始安装MySQL服务器。 yum -y insta