SELECT
@rownum := @rownum + 1 AS num,
t.*
FROM
( SELECT @rownum := 0 ) AS rownum,
( SELECT a.id, a.NAME, a.age FROM tablename a ORDER BY a.create_date DESC ) t
mybatis-plus mysql显示序号
最新推荐文章于 2024-06-13 09:00:30 发布
SELECT
@rownum := @rownum + 1 AS num,
t.*
FROM
( SELECT @rownum := 0 ) AS rownum,
( SELECT a.id, a.NAME, a.age FROM tablename a ORDER BY a.create_date DESC ) t