自动序号生成

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

 

posted @ 2022-10-15 16:24  .net&new  阅读(33)  评论(0)  编辑  收藏  举报