自动序号生成

SELECT (@i:=@i+1) AS rownum , v.id,v.UserName
FROM
userinfo v,
(SELECT @i := 0) AS i