mysql> select * from a; +-----+ | col | +-----+ | 0 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | +-----+ 8 rows in set (0.00 sec) mysql> set @i := 0; select @i := @i + 1 as `order`, a.* from a order by col desc; +-------+-----+ | order | col | +-------+-----+ | 1 | 7 | | 2 | 6 | | 3 | 5 | | 4 | 4 | | 5 | 3 | | 6 | 2 | | 7 | 1 | | 8 | 0 | +-------+-----+ 8 rows in set (0.00 sec)
mysql 排序后加序号
最新推荐文章于 2024-09-03 22:21:31 发布