select @rowNo:=@rowNo+1 as RowNo, a.* from table a , (select @rowNo:=0) b 转载于:https://www.cnblogs.com/xping/p/6703896.html