SELECT
@rownum := @rownum + 1 AS rownum,
tablename.*
FROM
(SELECT
@rownum := 0) r,
tablename ;
查询数据库记录加序号
最新推荐文章于 2022-11-20 19:31:22 发布
SELECT
@rownum := @rownum + 1 AS rownum,
tablename.*
FROM
(SELECT
@rownum := 0) r,
tablename ;