mysql - 쿼리에 변수 선언 방법

SELECT @name:=@name+1 AS NO, S1.*

FROM (

       SELECT * FROM `tablename`

        ) S1, (SELECT @name:=0) S2