SET @rownum = 0; SELECT (@rownum := @rownum + 1) AS rownum,seq, a.* FROM t_admin_menu a ORDER BY seq;