mysql rownum

SELECT @RNUM := @RNUM + 1 AS RNUM, a.* FROM testtable a, (SELECT @RNUM := 0) b

where a.column = 'test'

[출처] rownum (rownumber) 넘버링 (하늘 Java) |작성자 프라임