Re: Row Number Variable?

[ajay sharma]

Sean Daniels Wrote:
-------------------------------------------------------
> Is there a built in function in MySQL for
> returning the current row number in a result set?
>
> i.e.: select id, func() as myrow from table
>
> id myrow
> ---- ----------
> 10 1
> 11 2
> 12 3



Hi,

try this
SELECT @rownum:=@rownum+1 rownum, mytable.*
FROM (SELECT @rownum:=0) r, mytable;