Oracle rownumber() over()转换成MySQL使用的语句

Oracle语句：

select rownumber() over() as rownumber ,name,sex,age from user;

转换成MySQL语句:

select @r:=@r+1 as rownumber, name,sex,age from user,(select @r:=0) tmp;