Mysql查询得到的数据自动为结果排上序号

分类: 文章 • 2022-10-27 20:37:01

select
(@i:[email protected]+1) numbers, p.id, p.post_name as name, p.parent_id as pid, p.level, p.value, p.remark, p.create_time as createTime from reversion_post_info p left join reversion_post_info i on p.parent_id = i.id,(SELECT @i:=0) as numbers order by p.create_time desc

结果如下：