mysql 查询显示行号

设置一个初始值的变量
select @rn:=0
表数据关联

select @rn:=@rn+1 as rn

,t1.Fname as Fname

,t1.Fage as Fage

,t1.Fsex as Fsex

from t_user t1,select @rn:=0