一、添加行号,添加一次即可
SELECT
@r:=IFNULL(@r,0)+1 AS rownum ,
table.*
FROM
table
WHERE 1=1
二、将行号改为0
SELECT
@r:=0 AS rownum ,
table.*
FROM
table
WHERE 1=1
一、添加行号,添加一次即可
SELECT
@r:=IFNULL(@r,0)+1 AS rownum ,
table.*
FROM
table
WHERE 1=1
二、将行号改为0
SELECT
@r:=0 AS rownum ,
table.*
FROM
table
WHERE 1=1