mysql在查询结果集中添加一列信息标注当前数据是结果集的第N行

SELECT
    (@row_number :=@row_number + 1) AS row_number 
    ,*
FROM
    (SELECT @row_number:=0) AS it
    ,your_tbl