select (@i:=@i+1) as i,t.id from table t,(select @i:=0) as xh
在mysql中给查询的结果添加序号列
最新推荐文章于 2023-09-08 09:55:08 发布
select (@i:=@i+1) as i,t.id from table t,(select @i:=0) as xh