我使用下面的代碼查詢出了一張表結(jié)構(gòu)如下
SELECT xh,xm,bj,jd,rank FROM
(SELECT *,@rownum:=@rownum+1 AS rownum,IF(@pa=ff.bj,@rank:=@rank+1,@rank:=1) AS rank,@pa:=ff.bj
FROM
(SELECT xh,xm,jd,bj FROM totaltable GROUP BY bj,jd ORDER BY bj ASC, jd DESC) ff,(SELECT @rank:=0,@rownum:=0,@pa=NULL) tt) result
我想將rank 字段更新到totaltable表的對應(yīng)的學(xué)號（xh）的某字段(bpm)下默認(rèn)為空 應(yīng)該如何寫sql語句
將Mysql查詢的結(jié)果更新到本表的某字段下
慕運(yùn)維8079593
2019-03-06 13:20:11