mysql在查询结果中自动添加序号字段列

select (@rowNO := @rowNo+1) AS rowno,field1,field2,field3 from

(select field1,field2,field3 from table_name where field3 = '2012-04-21') a,

(select @rowNO :=0) b