mysql,实现数据库检索结果添加自增的序号

select t2.rowno 

from( select (@rownum:=@rownum+1) as rowno, t1.id  

 from news t1 ,(select (@rownum :=0) ) b 

 where .....) t2

 where t2.id=504