mysql 默认查询结果倒序

设置临时变量在table里面， 排序字段不用select 里面出现

select name from temp ,(select @row_number := 0) x ORDER BY (@row_number:=@row_number+1) desc