mysql数据库查询结果添加序号列

select (@rowNO := @rowNo+1) AS rowno,a.*
from product a,
(select @rowNO :=0) b