SELECT @rank:=@rank+1 as number, a.*
FROM (select * from user)a,
(SELECT @rank:= 0) b
@rank:=@rank+1 表示:序号从1开始,每次增加1
SELECT @rank:=@rank+1 as number, a.*
FROM (select * from user)a,
(SELECT @rank:= 0) b
@rank:=@rank+1 表示:序号从1开始,每次增加1