row number로 업데이트하기

UPDATE test 
SET 
    test = (@rownum:=1 + @rownum)
WHERE
    0 = (@rownum:=0) ORDER BY id;