Show Current Row Number

 

显示当前记录所在的查询结果集中的RowNumber

SELECT
  @rowNum:[email protected]+1 AS `rowNum`,
  t.*
FROM (SELECT
        @rowNum:=0) AS `r`,
  t