SELECT
(@rn:=@rn+1) as xh,a.*
FROM
(
select * from test
) a,(select @rn:=0) as it
mysql结果集添加序号列
最新推荐文章于 2024-02-20 09:26:18 发布
SELECT
(@rn:=@rn+1) as xh,a.*
FROM
(
select * from test
) a,(select @rn:=0) as it