MySQL ORDER BY 1 DESC的用法

一、问题

MySQL ORDER BY 1 DESC的用法

二、解决

1、对表中第n个字段按照倒叙排序

SELECT * FROM test ORDER BY 1 DESC;//对表中第1个字段进行倒叙排序
SELECT * FROM test ORDER BY 2 DESC;//对表中第2个字段进行倒叙排序

2、对表中select查询的第n个字段进行倒叙排序

select t_id.test.* from test order by 1 desc;//对表中t_id字段进行倒叙排序
SELECT t_id,e_id,test.* FROM testORDER BY 2 DESC;//对表中e_id字段进行倒叙排序