mysql查询实现插入自增列

Mysql中实现查询时插入自增列：

SELECT (@row_number:=@row_number + 1) AS num, firstName, lastName FROM employees,(SELECT @row_number:=0) AS t order by num DESC;