SELECT
@r :=@r + 1 rank,a.*
from (
SELECT * from mytable WHERE 1) a,
(SELECT @r := 0) b
MYSQL给选中结果添加赋予行号row number
最新推荐文章于 2024-04-30 18:45:35 发布
SELECT
@r :=@r + 1 rank,a.*
from (
SELECT * from mytable WHERE 1) a,
(SELECT @r := 0) b