设置一个初始值的变量
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
设置一个初始值的变量
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
本文标题：mysql 查询显示行号
本文链接：https://www.haomeiwen.com/subject/axubihtx.html
网友评论