Mysql中实现查询时插入自增列:
SELECT (@row_number:=@row_number + 1) AS num, firstName, lastName FROM employees,(SELECT @row_number:=0) AS t order by num DESC;
Mysql中实现查询时插入自增列:
SELECT (@row_number:=@row_number + 1) AS num, firstName, lastName FROM employees,(SELECT @row_number:=0) AS t order by num DESC;