mysql查询中如何实现oracle中的rownum函数的效果返回每行查询结果的行序号？

SELECT column,(@rownum := @rownum + 1) as ROWNUM_ALIAS FROM table, (SELECT @rownum :=0) r ORDER BY column ;