[mysql] rownum 출력

 

SET @rownum := 0;

SELECT
    @rownum := @rownum + 1 AS rnum 
    , m.menu_id, m.upper_menu_id, m.menu_nm 
FROM tb_menu m
;